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.

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.

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



