1000 Excel Formulas
Home
Categories
About
Search
DATEVALUE
Date
Converts a date in the form of text to a serial number
Syntax:
=DATEVALUE(date_text)
Example:
=DATEVALUE("1/1/2023")