Skip to main content

DATEVALUE

Converts date given as text to a serial number.

Syntax

=DATEVALUE(DateText)

Arguments

NameDescription
DateTextDate string to convert.

Return Value

The corresponding serial number defining the amount of days since 01.01.1900 or an Error Code

Example

FunctionResultComment
=DATEVALUE("18.5.2018")43238The 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.