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.

Two May end dates one day apart cross a whole-month boundary.

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.

A reversed pair is flagged for review before calculating.

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

Microsoft’s DATEDIF function reference