DATE
Returns the serial number which represents the date for given years, months and days.
Syntax
=DATE(Years, Months, Days)
Arguments
| Name | Type | Description |
|---|---|---|
| Years | Number | The year to be used, if a 2-digit number is entered, the current century is assumed |
| Months | Number | The month represented by a number between 1 and 12 |
| Days | Nuumber | A number, which specifies the day of the month |
Return
| Type | Description |
|---|---|
| Number | The corresponding date as serial number or an Error Code |
Examples
| Formula | Result | Comment |
|---|---|---|
| 43238 | The given serial number represents the 18th of May, 2018 |