DATEVALUE
Converts a date in the form of text to a serial number.
Date & TimeDates & Time Calculations
What it does
Converts a text string representing a date into an Excel serial date number.
Syntax
DATEVALUE(date_text)
Arguments
date_text(text) — Text string representing a date.
Examples
Convert text to date
Convert '2023-12-25' text.
FORMULA
=DATEVALUE("2023-12-25")RESULT
45285
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 45285 |