Documentation/How Tos/Calc: DATEVALUE function
From Apache OpenOffice Wiki
DATEVALUE
returns the date-time serial number, from a date given as text.
Syntax:
DATEVALUE(datetext)
- datetext is a date, expressed as text.
- DATEVALUE returns the date-time serial number, which may be formatted to read as a date.
Example:
DATEVALUE("2007-11-23")
- returns 39409, the date-time serial number for 23Nov2007 (assuming the default date-time starting date)