How many days in the month?
DAY of the month's last day is its length.
Task:
Monthly rent is split by days occupied, so you need each month's length. In B2:B6 give the number of days in the month of each date.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of EOMONTH
0/4The same formula in the other shapes it takes at work.
- EOMONTH Function
Find the last day of the month using EOMONTH.
CoreIntermediate - The first day of the month with EOMONTH
The end of last month plus one day.
Intermediate - Payment terms: end of the following month
A positive offset moves forward by whole months.
Intermediate - How many days in the month?
DAY of the month's last day is its length.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Date | Days in month |
| 2 | 2/10/2024 | |
| 3 | 2/10/2025 | |
| 4 | 4/30/2024 | |
| 5 | 7/4/2024 | |
| 6 | 9/1/2024 |
What this exercise teachesMay contain the answer
The last day's number is the month's length, leap years included, so there is no table of month lengths to maintain. February 2024 gives 29 and February 2025 gives 28 from the same formula.