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


The Excel ISOWEEKNUM function takes a specified date and returns a week number (1-54). The returned week follows the ISO

Read More »

RANK Function

The Excel Rank function returns the numeric value when compared to a list of numeric values. You can rank lists

Read More »
Scroll to Top