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.

January 31 moves to February 28 in 2026, while January 15 moves to February 15.

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.

Fixed anchor and chained offset split into March 31 and March 28.

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

Related Microsoft Excel reference