DATEVALUE

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

Syntax DATEVALUE ( text )

Argument Description

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

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

Examples This function returns 34399:

DATEVALUE("3/6/94")

This function returns 35058:

DATEVALUE("12/25/95")

See Also NOW, TIMEVALUE, TODAY