Export (0) Print
Expand All

DATEVALUE Function

Converts a date in the form of text to a date in datetime format.

DATEVALUE(date_text)

Term

Definition

date_text

Text that represents a date.

A date in datetime format.

The DATEVALUE function uses the locale and date/time settings of the client computer to understand the text value when performing the conversion. If the current date/time settings represent dates in the format of Month/Day/Year, then the string, "1/8/2009", would be converted to a datetime value equivalent to January 8th of 2009. However, if the current date and time settings represent dates in the format of Day/Month/Year, the same string would be converted as a datetime value equivalent to August 1st of 2009.

If the year portion of the date_text argument is omitted, the DATEVALUE function uses the current year from your computer's built-in clock. Time information in the date_text argument is ignored.

The following example returns a different datetime value depending on your computer's locale and settings for how dates and times are presented.

  • In date/time settings where the day precedes the month, the example returns a datetime value corresponding to January 8th of 2009.

  • In date/time settings where the month precedes the day, the example returns a datetime value corresponding to August 1st of 2009.

=DATEVALUE("8/1/2009")

Community Additions

ADD
Show:
© 2014 Microsoft