The DAY function returns the day from a date as a number between 1 and 31. If the day is blank, it returns 0.
For example, you can use the DAY function to extract the day of an employee's start or end date.
Syntax
DAY(Date)
Arguments
| Argument | Data type | Description |
| Date | Date | The date to extract the day from. |
The DAY function returns a numeric result.
Syntax example
DAY(DATE(2018, 1, 4))
In this example, the formula returns the number 4.
Excel equivalent
Examples
In this example, the date line items Contractor start date and Contractor end date contain start and end dates for different contractors.
The DAY(Contractor end date) formula returns the day of the date from Contractor end date.
| James Smith | Simon Peters | |
| Contractor start date | 08/31/2019 | 09/22/2019 |
Contractor end date
| 02/29/2020 | 03/20/2020 |
Contractor end day
| 29 | 20 |
