Manuals/calci/DATEVALUE
Jump to navigation
Jump to search
DATEVALUE(textdate)
- where text date 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 is starting from 1/1/1900 .
- i.e the serial number of "8/15/1947" or "15-Aug-1947" is 53918(calci) 17394(Excel).
- This function will give the result as Error when the textdate is below range of 1/1/1900.
- Also 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(CALCI)=22074(EXCEL)
- DATEVALUE("1-APR-1976")=27851
- DATEVALUE("12/12")=37237(CALCI)41620(EXCEL) for the current year 2013.
See Also