Category: Date and Time function
This function returns a date serial number based on the year, month and day numeric values.
| Argument | Type | Description |
|---|---|---|
| year | Number | A number value representing the 4-digit year of the date. |
| month | Number | A number value representing the month (1 to 12) of the date). |
| day | Number | A number value representing the day-of-the-month number (1 to 31). |
Return value type: Date serial number
makedate(2014, 1, 1) //Returns 41640 (Equivalent to January 1st, 2014.)
makedate(2020, 2, 28) //Returns 43889 (Equivalent to February 28th, 2020.)