How to Use DATEVALUE Function

The DATEVALUE function is to convert a date from text format to a serial number.




The date_text is required, which is a date in text format, e.g., "2001/2/4".


The dates in Excel are stored the sequential serial numbers and can only be a date between January 1, 1900 and December 31, 9999.

Download: DATEVALUE Function

Leave a Reply