Functions
DATEVALUE
Converts a date string to a serial number
Try it
When to use it
When should I use DATEVALUE?
Use DATEVALUE to convert a date stored as text into a numeric serial number — useful when dates imported from external systems arrive as strings and you need to perform arithmetic or comparisons on them.
Used in
Syntax
DATEVALUE(date_text)Examples
=DATEVALUE("6/7/2026") // => 46180
=DATEVALUE("2026-06-07") // => 46180
=DATEVALUE("1969-7-20") // => 25404