DATEVALUE

See also A-Z Spreadsheet Function List

Description Returns the serial number of a date supplied as a text string.

Syntax DATEVALUE(text)

text is a date, in text format, between January 1, 1900, and December 31, 2078. If you omit the year, the current year is used.

See Also NOW , TIMEVALUE , and TODAY functions

Examples DATEVALUE(“3/6/94”) returns 34399

         DATEVALUE(“12/25/95”) returns 35058