Tries to convert a any value into a date
Summary: Return date serial number from given text.
Syntax: DATEVALUE( Text D )
Semantics: This computes the date of the text string D, using the current locale. This function accepts ISO date format (YYYY-MM-DD), which is locale-independent. If the text of D has a combined date and time format, e.g. YYYY-MM-DD HH:MM:SS, the integer part of the date serial number is returned. If the text of D represents a number, the number is treated as serial date number (days since 1.1.1900) and is converted into a date.
|=DateValue("1996/12/25")||Dec 25, 1996|
| BDate = "2006/11/1" (string)
|Nov 1, 2006|
|=DateValue(1)||Jan 1, 1900|