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

CONCAT Function

The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016

Read More »

PPMT Function

The PPMT Function in Excel is used to calculate the principle of a given loan payment. If all you a

Read More »
Scroll to Top