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:

Argument Description
date_text A 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