DATEVALUE

Description

DATEVALUE returns the serial number of a date supplied as a text string.

Syntax

DATEVALUE ( text )

Parameter	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")

Also, see