DATEVALUE()
Syntax. DATEVALUE(date_text)
Definition. This function converts a date formatted as text into a serial number based on the Excel date system.
Arguments
Date_text (required). A text value in an Excel date format
Background. If a date is formatted as text (for example, if it was imported in this format), use the DATEVALUE() function to convert the date into a serial number so that you can use the result for other calculations.
Most functions convert dates formatted as text automatically into serial numbers, but if you use imported data or worksheet functions from a third-party add-in, this might not always be true. To ensure that a date is converted, use the DATEVALUE() function.
For example, “12/12/2005” and “9/9/2001” are strings in quotation ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
