Count dates shared by two inclusive intervals
Fill C2:C5 with the number of calendar dates shared by each A:B interval and the inclusive reporting window G2:G3. Count both endpoints, return 0 for no overlap, and return Review when a source end precedes its start. Dates are whole numeric serials from 2000 through 2099; G3 must be on or after G2.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Fill C2:C5 with the number of calendar dates shared by each A:B interval and the inclusive reporting window G2:G3. Count both endpoints, return 0 for no overlap, and return Review when a source end precedes its start. Dates are whole numeric serials from 2000 through 2099; G3 must be on or after G2.
No account. No upload. Just try it.