DATEVALUE
Converts date given as text to a serial number that Streamsheets recognizes as a date.
Syntax
=DATEVALUE(DateText)
Arguments
| Name | Type | Description |
|---|---|---|
| DateText | String | Date string to convert. |
Return
| Type | Description |
|---|---|
| Number | The corresponding serial number defining the amount of days since 01.01.1900 or an Error Code |
Examples
| Formula | Result | Comment |
|---|---|---|
| 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. |