EXCELDATE
Syntax
=EXCELDATE(value)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number or Date | If value is a date, it gets passed through unchanged. Otherwise it returns the date which is value days after Dec 30, 1899. |
Examples
=EXCELDATE(1)→Dec 31, 1899 12:00 AM
=EXCELDATE(43800)→Dec 31, 2019 12:00 AM
=EXCELDATE(DATE(2019, 01, 01))→Jan 1, 2019 12:00 AM
Updated 2 months ago