DATEVALUE
Converts date given as text to a serial number.
Syntax
=DATEVALUE(DateText)
Arguments
Name | Description |
---|---|
DateText | Date string to convert. |
Return Value
The corresponding serial number defining the amount of days since 01.01.1900 or an Error Code
Example
Function | Result | Comment |
---|---|---|
=DATEVALUE("18.5.2018") | 43238 | The number to the left of the decimal define the days since 01.01.1900. The number to the right of the decimal define the fraction of the day. |