Instructions for using the DATEVALUE function to convert dates in Excel
Instructions for using the DATEVALUE function to convert dates in Excel: The DATEVALUE function is used to convert a date stored as text into a serial number format that Excel recognizes as a date. Follow the steps below to learn how to use the DATEVALUE function in Excel.
1. DATEVALUE function structure
- Date_text: a required argument, which is the date written as text or a reference to a cell containing a date in text format.
- Date_text is a required argument and can only omit the year part of the argument. That means if you only enter the day and month, the DATEVALUE function will default to the current year.
- Date_text must be enclosed in parentheses to express the date value. Otherwise, the function will return an error value of #VALUE.
2. How to use the DATEVALUE function
For example, to convert the date “11/4/2019” to a serial format, use the following formula:
If you use the DATEVALUE function to reference a cell with a date format that is not text, the function will return the error value #VALUE!.
In this case, you need to change the date format of the cell to text by adding:
Now, the cell will be considered as text and the DATEVALUE function will work.
If the year value is omitted, the function will assume the current year.
In conclusion, this article has guided you through how to use the DATEVALUE function in Excel. We hope that you have understood how to use this function after reading this article. Good luck!