DAY
Pulls the day of the month from 1 to 31 out of a date: for example, to check who paid after the due day.
DAY(serial_number)- serial_number
- A cell with a date, for example B2, or a formula that returns a date.
Return value
A number from 1 to 31: the day of the month of the date.
Examples
Rent payment day
fx
A
B
C
D
1
2
3
4
5
6
7
Tenant
Payment date
Day
Coffee shop
03.10.2026
Florist
09.10.2026
Shoe repair
14.10.2026
Pharmacy
22.10.2026
Sheet1
Details
DAY returns only the day of the month. The month and year are lost: March 5 and October 5 both give 5.
The function is useful for checks like "pay by the 10th": compare the result with the threshold or use it in IF.
Common mistakes
- DAY is confused with the day of the week. Whether it's Monday or Friday is what WEEKDAY shows.
- The cell holds text that Excel didn't recognize as a date. The function returns #VALUE!.