Documentation/How Tos/Calc: DATEVALUE function
From Apache OpenOffice Wiki
CALC FUNCTIONS
- Date & Time FunctionsToday*Now*Year*Month*Day *Weekday*Hour*Minute*Second*Date
- DatevalueTime*Timevalue*Eomonth*Edate*Workday*Networkdays*Days*Days360*Daysinmonth*Daysinyear*Weeks*Weeksinyear*Weeknum*Weeknum_add*Months*Years*
Contents
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)
-