Documentation/How Tos/Calc: DATEVALUE function
From Apache OpenOffice Wiki
DATEVALUE
returns the date-time serial number, from a date as text.
Syntax:
DATEVALUE(datetext)
- datetext is a date, expressed as text.
Example:
DATEVALUE("2007-11-23")
- returns 39409, the date-time serial number for 23Nov2007 (assuming the default date-time starting date)
See also:
Issues:
The forthcoming ODFF standard requires DATEVALUE to return the date-time serial number as a date, so Calc should format the result as a date. However currently Calc seems to return the date-time serial number as a number, requiring the user to format the result manually.