This function returns a DateTime object of the specified date.
DATEVALUE(date_string)
The argument for this function is a date as a string.
Use this function to convert a date represented by text to a DateTime object in standard format.
Accepts string data. Returns a DateTime object.
DATEVALUE(B18)
DATEVALUE(R18C2)
DATEVALUE("2004/10/6") gives the result 10/6/2004 12:00:00 AM