Google Sheets DATEVALUE Function
The main job of the DATEVALUE function is to convert a text format into a valid date. That means the Google sheets DATEVALUE function converts a date which is represented as a text in the proper Excel date format.
You can understand this by this example – the formula = DATEVALUE(“12/31/2020”) will return a serial number according to the Excel date system, which will represent – December 31, 2020. The proper Excel dates are more useful in worksheets than text dates because you directly manipulate them using formulas & pivot tables to create summaries and perform various date-related analyses.
DATEVALUE Function Return Value
It will return a serial number that represents a specific date as per Excel.
DATEVALUE Function Syntax
= DATEVALUE(date-text)
Where:
- date-text: Any valid date provided in the text format.
How to Use Google Sheets DATEVALUE Function?
In case date-text is the address of the cell, the value of the cell must be the text. If you want to enter the date-text directly into the formula, you should enclose it in the quotes. If it happens that you have referred a date-text to a cell that does not contain a date formatted as a text, then you will get the return result as a #VALUE error.