The review cadence starts January 31, 2026. Enter =DATE(2026,1,31) in B2 and =EDATE(B2,1) in C2. Format C2 as a date. The first review lands on February 28.
Choose which date owns the cadence
For a fixed January anchor, =EDATE(B2,2) gives March 31. For an offset from the most recent scheduled review, =EDATE(C2,1) gives March 28. Label the column so someone can tell which rule they inherited.

Illustrated first-month check. February has no 31st in this example.
Test a date that February can keep
In a scratch row change the January day to 15 and expect February 15. If the policy is specifically the last day of every month, use an end-of-month calculation. Treat weekends or holidays as a separate scheduling rule.

Illustrated policy decision. Decide which date supplies the next offset.



