Skip to content

How to Use Excel DATEVALUE Function?

Listen to this article
DATEVALUE functionPin
DATEVALUE function

DATEVALUE Function in Excel: In Excel, we can insert any kind of input value such as numbers, strings, letters, symbols, dates, and so on. On that note, if you want to get the serial number of the specific date which is associated with Excel, then we will show you how.

We all know that Excel provides various built-in formulas and functions to achieve your goals. So, we suggest you use the DATEVALUE function in order to get the appropriate serial number of a particular date.

Let’s see the usage of the Excel DATEVALUE Function with its syntax and examples. Get the official version of MS Excel from the following link:

DATEVALUE Function in ExcelPin
DATEVALUE Function in Excel

Explanation of DATEVALUE Function

  • It is one of the built-in functions in Microsoft Excel.
  • The DATEVALUE function converts a given date that is represented as a text string into a valid Excel date.
  • For example, if we give the date value as 3/10/1975, it returns the associated serial number (27463) of that date.
  • In case, the given input date is not in the correct format, it shows you the #value error.
  • The default system date format is MM/DD/YY


  • Here, you will see the syntax of the DATEVALUE function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.


Practical Examples

Let’s Evaluate the DATEVALUE Function with the following examples and know how it works.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • Let us assume the date 5 May 2013, and we entered it in cell B3, as shown in the below image.
Enter the formulaPin
Enter the formula
  • After that, we need to apply the above-mentioned formula in order to result in the spreadsheet.
Enter the formulaPin
Enter the formula
  • Next, you will need to hit the Enter button in order to get the exact serial number of the given input date.
  • Let’s see another valid format of the input date, and it might be helpful to enter it as simply as possible.
  • In the following example, we have entered the date in cell B3, and we will get the result in Cell D3.
  • And you can use any of the below-mentioned formats to give input as you wish.

=DATEVALUE(“18 Jan”) or =DATEVALUE(“Jan 18”)

Enter the datePin
Enter the date
  • After entering the formula, you have to click on the Enter button on your keyboard to get the result.

#VALUE Error While using DATEVALUE

  • When you enter the Date format incorrectly in the DATEVALUE function it will return the #VALUE Error.
  • To fix this, you need to change the input date into the correct format.
Get Value Error Pin
Get Value Error

A Quick Synopsis

We hope this article gives you complete instructions on how to use the DATEVALUE Function in Excel. Stay Connected to get instant updates. Please leave a comment in the below section, it helps to enhance our write-up. To learn more about Excel functions, then visit our webpage

Video Explanation

In the below-given video, you will learn how to use the DATEVALUE function in Excel.

Also See:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...