Find the last day of the month
Jump from any date to the last day of its month — handy for period-end reports.
The formula
=EOMONTH(A2, 0)How it works
Before
2026-06-11
After
2026-06-30
EOMONTH jumps to the last day of the month (here June 30).
Jump from any date to the last day of its month — handy for period-end reports.
=EOMONTH(A2, 0)EOMONTH jumps to the last day of the month (here June 30).