Documentation/Calc Functions/DATEVALUE

Function name:
DATEVALUE

Category:
Date and Time

Summary:
Converts a valid date expressed as a text string into a date-time serial number.

Syntax:
DATEVALUE(Text)

Returns:
Returns an integer value which is the date-time serial number corresponding to the date supplied as a text string argument.

Arguments:
Text is a valid date expression, surrounded by quotation marks, or a reference to a cell containing a valid date expression formatted as a text string.


 * If Text does not contain a valid date expression, then DATEVALUE reports an invalid argument error (Err:502).
 * If Text references a cell which contains a valid date expression and has its formatting set to Date, then DATEVALUE will return an invalid argument error (Err:502). This is because Calc handles the value in that cell as a number rather than a text string.
 * If Text includes time components, they are ignored by DATEVALUE which only returns the integer part of the date-time serial number.

Related LibreOffice functions:
DATE

TIME

TIMEVALUE

VALUE

ODF standard:
Section 6.10.4, part 2

Equivalent Excel functions:
DATEVALUE