DATEVALUE

This function returns a DateTime object of the specified date.

Syntax

DATEVALUE(date_string)

Arguments

[Required] The argument for this function is a date as a string.

Remarks

Use this function to convert a date represented by text to a DateTime object in a standard format.

Examples

DATEVALUE(B18)

DATEVALUE(R18C2)