EOMONTH
Returns the last day of a month.
How it’s written
EOMONTH(date, months)Example
| A | |
|---|---|
| 1 | Date |
| 2 | 46,096 |
=EOMONTH(A2,0)Result: 46,112
Returns March 31, 2026. A 0 means the same month.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
It handles February and leap years correctly.
Practice it properly
Calculating with dates gives you real tasks, with your formulas tested on data you haven’t seen.