What is DATEVALUE function in Excel?
The DATEVALUE function is one of the Date & Time functions of Excel.
It Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code.
We can find this function in Date & Time of insert function Tab.
How to use DATEVALUE function in excel
- Click on an empty cell (like F5).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select Date & Time category.
5. Select DATEVALUE function
6. Then select ok.

7. In the function arguments Tab you will see DATEVALUE function.
8. Date text section is the text that represents a date in a Microsoft Excel date format, between 1/1/1900 or 1/1/1904 (depending on the workbook’s date system) and 12/31/9999.
9. You will see the result in the formula result section.

Examples of DATEVALUE function in excel

Python code for DATEVALUE function
import datetime
x = datetime.datetime(1990, 1, 1)
print(x.strftime("%x"))
What is the purpose of DATEVALUE function?
What is the Return value of DATEVALUE function?
How many arguments does DATEVALUE function have?
This function has just 1 Argument.
The argument of ABS function is number.
The argument of ABS function is required and not optional.
Which version of excel supports DATEVALUE function?
This function is available for all excel versions (2003-2019)
Errors in DATEVALUE function
DATEVALUE related functions
- CONCAT function
- Use TIMEVALUE function to convert a text time to an Excel serial number for a time, a number from (12:00:00 AM) to (11:59:59 PM).
- VALUE function
- NUMBERVALUE function