DATEVALUE

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

Syntax

=DATEVALUE(DateText)

Arguments

Name	Type	Description
DateText	String	Date string to convert.

Return

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

Examples

Formula	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.