Skip to main content

DATEVALUE

The DATEVALUE function converts a date entered in a regular format into a number.

This function can be useful when dates are presented in text form and need to be converted for further calculations or analysis.

Syntax​

DATEVALUE(date)

ArgumentDescriptionPermitted values
dateThe date in text format that needs to be convertedDate as a text string in quotation marks or a reference to a cell

Examples of use​

Use with different date formats

=DATEVALUE("03/15/2023")

The result will be the number 45,000.

Use with different date formats

=DATEVALUE("1-jan-2024")

Result: 45,292.

Notes​

  • Make sure that the text representation of the date matches one of the formats recognized by the spreadsheet editor, otherwise the function will return the #VALUE! error.
  • This function recognizes most common text date formats.
  • The date string must be enclosed in quotation marks.
  • Supported formats may vary depending on regional and language settings.
  • The result of the function is a number that can be formatted as a date using a number format.