Date
DAY
Definition
DAY returns the day of the month from a date, from 1 to 31.
Syntax
=DAY(serial_number)
Arguments
| Argument | Meaning |
|---|---|
serial_number |
A date, or the cell holding it. |
Worked example
A clinic logs visit dates. The dates are in B2:B4.
| A: Visit | B: Date |
|---|---|
| Check | 4 Nov 2021 |
| Follow-up | 8 Mar 2023 |
| Review | 20 Oct 2023 |
Formula: =DAY(B2)
Result: 4. 4 November 2021 is day 4 of the month.
Practice
Cell A2 holds the date 15 June 2024. In B2, write a formula that returns the day of the month of that date.
- In B2, write a DAY formula for A2.
- B2 should show the day of A2.
Step 1 of 2
Enter =DAY(A2) in B2.
A2 is 15 June 2024, so the day is 15.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses DAY.
B2 now shows 15.
Related functions
DAY reads the day of the month from a stored date, and TODAY supplies the current date when you need today's day number.
Common mistake
Using DAY when you wanted the weekday: DAY of 4 November 2021 is 4, the day of the month, not Thursday.