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.


Leave a Reply

Scroll to Top