The equipment trial began on January 15, 2026. Its report counts whole completed months, so the May anniversary is the useful test.
Compare the day before and the anniversary
Put =DATE(2026,1,15) in B2 and =DATE(2026,5,14) in C2. Use =DATEDIF(B2,C2,"M") in D2 and expect 3. Change C2 to May 15 and expect 4.

Illustrated anniversary check. Keep both dates beside the result.
Check date order and shorter months
Review any end date before the start instead of using it in the calculation. If a start falls on the 29th, 30th, or 31st, test a shorter destination month in the receiving spreadsheet and agree how the report defines a completed month. Keep the original dates available for that review.

Illustrated input check. Agree on a rule for months without an anniversary day.



