Returns the serial number of the date represented by date_text. Use DATEVALUE to convert a date represented by text to a serial number.
Date_text is text that returns a date in a Microsoft Excel date format. Using the default date system in Microsoft Excel for Windows, date_text must represent a date from January 1, 1900, to December 31, 9999. Using the default date system in Microsoft Excel for the Macintosh, date_text must represent a date from January 1, 1904, to December 31, 9999. DATEVALUE returns the #VALUE! error value if date_text is out of this range.
If the year portion of date_text is omitted, DATEVALUE uses the current year from your computer's built-in clock. Time information in date_text is ignored.
- Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information, see NOW.
- Most functions automatically convert date values to serial numbers.
The following examples use the 1900 date system:
DATEVALUE("8/22/55") equals 20323
DATEVALUE("22-AUG-55") equals 20323
Assuming your computer's built-in clock is set to 1993 and you are using the 1900 date system:
DATEVALUE("5-JUL") equals 34155