Skip to main content

DATEVALUE function

The DATEVALUE function is one of the date and time functions. It is used to return a serial number of the specified date.

Syntax​

DATEVALUE(date_text)

The DATEVALUE function has the following argument:

ArgumentDescription
date_textA date from January 1, 1900, to December 31, 9999.

Notes​

How to apply the DATEVALUE function.

Examples​

The figure below displays the result returned by the DATEVALUE function.

DATEVALUE Function