The next reporting cutoff is the last calendar day of the following month. Use EOMONTH even if you started halfway through the current month.
Use an offset of one month
Put =DATE(2028,1,15) in B2. Use =EOMONTH(B2,1) in C2 and format it as a date. The result should be February 29, 2028. Try an offset of 0 and expect January 31.

Illustrated month-end timeline. The starting day can be mid-month.
Check a non-leap February too
Change the starting year to 2027 and keep offset 1. The result should be February 28, 2027. Label the output Next calendar month end. If the cutoff is the last working day, apply the separate working-day rule the report uses.

Illustrated leap-year checks. Use a date format on the output.



