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