DATEVALUE function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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)
See Also
