Difference between revisions of "Manuals/calci/DATE"
Jump to navigation
Jump to search
Line 19: | Line 19: | ||
*[[Manuals/calci/DATEVALUE | DATEVALUE ]] | *[[Manuals/calci/DATEVALUE | DATEVALUE ]] | ||
− | *[[Manuals/calci/ | + | *[[Manuals/calci/DAYS360 | DAYS360 ]] |
==References== | ==References== | ||
[http://en.wikipedia.org/wiki/Calendar_date DATE] | [http://en.wikipedia.org/wiki/Calendar_date DATE] |
Revision as of 03:16, 31 March 2014
DATE(yy,mm,dd)
- represents the year
- is the month of the year
- is the date.
Description
- This function gives the sequential serial number for the given date.
- Here represents the year and it should start from 1 or more than 1.
- is the month of the year and it is from 1 to 12(January to December).
- 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