DATEVALUE
Returns the internal date number for text in quotes.
The internal date number is returned as a number. The number is determined by the date system that is used by LibreOffice to calculate dates.
If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion.
Syntax
DATEVALUE("Text")
\<emph\>Text\</emph\> is a valid date expression and must be entered with quotation marks.
Example:
DATEVALUE("7/20/54") yields 19925