EOMONTH Function
Find the last day of the month using EOMONTH.
Task:
You need to determine the last day of the month for a list of dates. Find the last day of the month in column B for the dates in column A using the EOMONTH function.
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 | Last Day of Month |
| 2 | 1/15/2023 | |
| 3 | 5/20/2023 | |
| 4 | 2/15/2024 |
Functions used here
What this exercise teachesMay contain the answer
EOMONTH function is useful for finding the last day of a month for financial calculations, reporting, or scheduling.