Difference between revisions of "Manuals/calci/DEGREES"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''DATES(yy,mm,dd)'''</div><br/> | <div style="font-size:30px">'''DATES(yy,mm,dd)'''</div><br/> | ||
| − | *'yy' represents the year | + | *where 'yy' represents the year, 'mm' is the month of the year and 'dd' is the date . |
| − | + | ||
| − | |||
==Description== | ==Description== | ||
Revision as of 00:40, 14 November 2013
DATES(yy,mm,dd)
- where 'yy' represents the year, 'mm' is the month of the year and 'dd' is the date .
Description
- This function gives the sequential serial number for the given date.
- Here 'yy' represents the year and it should start from 1 or more than 1.
- 'mm' is the month of the year and it is from 1 to 12(January to December).
- 'dd' is the date of the month of the year and it is from 1 to 31.
Examples
- DATE(99,2,1)=2/1/99
- DATE(1600,12,31)=12/31/1600