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.

Offset 1 moves from the January start to the end of February.

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.

February 2028 ends on the 29th and February 2027 ends on the 28th.

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

Microsoft’s EOMONTH function reference