Skip to main content
Version: Streamsheets 2.5

DATEVALUE

Converts date given as text to a serial number that Streamsheets recognizes as a date.

Syntax

=DATEVALUE(DateText)

Arguments

NameTypeDescription
DateTextStringDate string to convert.

Return

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

Examples

FormulaResultComment
=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.