Excel DATEVALUE Function

HomeExcel FunctionsExcel DATEVALUE Function (Example + Sample File)


The Excel DATEVALUE Function is listed under Microsoft Excel's Date Functions category. It returns a date after converting a text (which represents a date) into an actual date. In simple words, it converts a date into an actual date which is formatted as text.

How to use it

To learn how to use the DATEVALUE function in Excel, you need to understand its syntax and arguments:




  • date_text: The date which is stored as a text and you want to convert that text into an actual date.


  • You can directly enter a date into the function by using a double quotation mark.
  • If you use a date that has no month in it, it will not convert that date into a date serial number.


To master DATEVALUE function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have inserted a date directly into the function by using double quotation marks. If you skip adding these quotation marks it will return a #NAME? error in the result.

In the below example, all the dates on the left side are in textual format.

  1. A simple textual date which we have converted into a valid date.
  2. A date with all three components (Year, Month, or Day) in numbers.
  3. If there is no year in the textual date, it will take the current year as the year.
  4. And if you have month name is in alphabets and no year, it will take the current year as a year.
  5. If you don’t have the day in your textual date it will take 1 as the day number.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.