Manuals/calci/DATEVALUE

DATEVALUE(textdate)

• where $textdate$ represents a date in CALCI format

Description

• This function gives the serial number of the given $textdate$.
• This is used to convert the a date in to a specified serial number.
• By default , the serial number starts from 1/1/1900.
• i.e the serial number of "8/15/1947" or "15-Aug-1947" is 53918(Calci).
• This function will give the result as Error, when the $textdate$ is below 1/1/1900.
• If the year value is not entered in the $textdate$, this function will consider the current year.
• Time information in $textdate$ is ignored.

Examples

• =DATEVALUE("3/20/2005")=38431
• =DATEVALUE("6/7/1960")=58599
• =DATEVALUE("1-APR-1976")=27851
• =DATEVALUE("12/12")=37237 for the current year 2013.

See Also

• DATE
• DAY

References

Complex Numbers