Difference between revisions of "Documentation/How Tos/Calc: DATEVALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
Line 2: | Line 2: | ||
== DATEVALUE == | == DATEVALUE == | ||
− | returns the date-time serial number, from a date as text. | + | returns the date-time serial number, from a date given as text. |
− | + | ||
=== Syntax: === | === Syntax: === | ||
Line 10: | Line 9: | ||
: <tt>'''DATEVALUE'''</tt> returns the date-time serial number, which may be formatted to read as a date. | : <tt>'''DATEVALUE'''</tt> returns the date-time serial number, which may be formatted to read as a date. | ||
− | |||
=== Example: === | === Example: === | ||
<tt>'''DATEVALUE("2007-11-23")'''</tt> | <tt>'''DATEVALUE("2007-11-23")'''</tt> | ||
: returns <tt>'''39409'''</tt>, the date-time serial number for 23Nov2007 (assuming the default date-time starting date) | : returns <tt>'''39409'''</tt>, the date-time serial number for 23Nov2007 (assuming the default date-time starting date) | ||
− | |||
=== See also: === | === See also: === | ||
Line 24: | Line 21: | ||
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | '''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]''' | ||
− | |||
− | |||
− | |||
− |
Revision as of 10:04, 16 January 2008
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)