Converts a date stored as text into a serial number that Excel recognizes as a date.
Syntaxis
DATEVALUE(date_text)Argumenten
date_textvereist
A string that represents a date in an Excel-recognized format.
The DATEVALUE function is useful when a worksheet contains dates in a text format that you want to use in calculations. It returns the serial number representing the date according to Excel's date-time system. If the date_text argument includes year information, it is used; otherwise, it defaults to the current year.
=DATEVALUE("2023-01-01")→44927Converts the text string '2023-01-01' into its corresponding serial number.
Select a cell
Click on the cell where you want to display the converted date value.
Enter the formula
Type =DATEVALUE("YYYY-MM-DD") and press Enter.
Format the cell
Change the cell format to 'Date' if you want to see the date instead of the serial number.
Excel stores dates as serial numbers to perform calculations; you must apply a Date format to the cell to see it as a standard date.