The DATEVALUE function converts a date in the form of text to a serial number representing a date in Excel.

DATEVALUE takes 1 required argument and no optional arguments:

Syntax: DATEVALUE(date_text)

#1)
Undertanding how Excel stores dates as serial numbers:
#2)
Using the DATEVALUE function:

Summary

The DATEVALUE function converts a date in the form of text to a serial number representing a date in Excel. The important thing is to become comfortable with the concept of how Excel views dates as serial numbers.
comments powered by Disqus