DATEVALUE Formula

DATEVALUE formula convert date which is in text form into a date format.

Syntax of DATEVALUE formula

DATEVALUE( date )

Parameters Details

date : A date which is available in text format.

Returns

The DATEVALUE function returns a date.

DATEVALUE Formula Example
DATEVALUE Formula Example