Date
Reading the day of the month
Definition
Reading the day of the month from a date means giving DAY the cell that holds the date.
Syntax
=DAY(serial_number)
Arguments
| Argument | Meaning |
|---|---|
serial_number |
The cell that holds the date whose day of the month you want. |
Worked example
An invoice list stores issue dates in B2:B4.
| A: Invoice | B: Issued |
|---|---|
| INV-8 | 3 Aug 2017 |
| INV-9 | 28 Aug 2017 |
| INV-10 | 1 Sep 2017 |
Formula: =DAY(B2)
Result: 3. 3 August 2017 falls on day 3 of the month.
Practice
Cell A2 holds the date 20 May 2021. 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 20 May 2021, so the day is 20.
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 20.
The next lesson is Reading the day of the week.
Related functions
DAY is the function that reads the day of the month from the date.
Common mistake
Pointing DAY at the invoice code, as in =DAY(A2): INV-8 is text, so the formula returns an error instead of 3.