DATEVALUE
Description
Returns a numerical (serial) date value based on the specified text.
Syntax
DATEVALUE(
date_text
)
- date_text: The text to convert to a numerical date value. Example: =DATEVALUE( "06/06/16" ).
Example
Formula | Result |
|---|---|
=DATEVALUE("12/1/2018") | 43435 |
=DATEVALUE("Dec 1, 2018") | 43435 |
=DATEVALUE("1-Dec-2018") | 43435 |
=DATEVALUE("Dec 1") | 43435 |
Related Functions
DATESBETWEEN