Manuals/calci/DATETOEXCEL

DATETOEXCEL(Date)

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Date} is any date.

Description

This function converts a date that is stored as text to a serial number.
This function is useful in where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.
The date format is mentioned as [DATE]
If the year portion of the date_text argument is omitted, the DATEVALUE function uses the current year from your computer's built-in clock. Time information in the date_text argument is ignored.