How to Use Excel DATEVALUE Function?

Ads

Listen to this article

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:

https://www.microsoft.com/en-in/microsoft-365/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.

Syntax

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.

=DATEVALUE(“date-string”)

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.

After that, we need to apply the above-mentioned formula in order to result in the spreadsheet.

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”)

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.

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 Aawexcel.com.