Hi all,

I would like to calculate the number of overlapping days in multiple date ranges. This is a set of pharmacy data for which I want to know how many days a patient has supply of all his medications. Attached is a sample data, and I would like to know how many days the patient has all 3 of his medications.

Appreciate your help on this!

Sample data.xlsx