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)
Argument |
Description |
Permitted values |
|---|---|---|
date |
The date in text format that needs to be converted |
Date 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.