Manuals/calci/DATE
Jump to navigation
Jump to search
Syntax
Examples
''''''' ''''
Description
DATE
Let's see an example in Column1Row1,Column2Row1 and Column3Row1
I.e. = DATE(C1R1,C2R1,C3R1)
=DATE(2007,6,2) is 6/2/2007
=DATE(yyyy,mm,dd)
where,
yyyy - represents the year and can be 1 to 4 digits.
mm - represents the month of year and can be from 1 to 12(january to december).
dd - represents the day of the month from 1 to 31.
It gives the sequential serial number that represents a particular date.
Remarks
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2007 | 6 | 2 | 5 |
| Row2 | 6/2/2007 | 8 | 9 | 128 |
| Row3 | 12 | 67968 | 14 | 15 |
| Row4 | 17 | 18 | 10000 | 20 |
| Row5 | 2036 | 67994 | 10025 | 168 |
| Row6 | 12 | 0.850904 | 1.619775 | 0.525322 |
