DATEVALUE Function

The Excel DATEVALUE function is used to convert a date in Excel to text.

 =DATEVALUE (date_text) 
  • date_text – Date in text format.

In the example below, we convert the date 1/1/2006 to the text number of “38718.”

If you receive a “#VALUE error,” this means that the date_text is referencing a cell that is not formatted as text.

DATEVALUE Function

Leave a Comment

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

Scroll to Top
Send this to a friend