One equipment check repeats every four calendar days and another every six. Both happen November 2. Find the next day both teams need the equipment.

Add the least common multiple to the shared date

Enter 4 in B2 and 6 in C2. In D2 enter =DATE(2026,11,2). In E2 enter the following and format it as a date:

=D2+LCM(B2,C2)

The first shared offset is 12. Four-day checks run at 4, 8 and 12 days, while the six-day checks run at 6 and 12 days.

The four-day schedule reaches days 4, 8 and 12. The six-day schedule reaches 6 and 12.

Illustrated calendar offsets. Day zero is the known shared check.

Check the date and how the schedules actually repeat

The next shared date should be November 14, 2026. This formula uses positive whole-day intervals and a known shared start. If checks skip weekends or started on different dates, compare their actual occurrence dates. Label D2 as the last known shared check so the next reader understands the anchor.

November 2 plus 12 days lands on November 14, 2026.

Illustrated date check. Calendar-day cycles use the same start date.

Microsoft’s LCM function reference