Hello everyone. I have a list of projects and their related activities, along with the activities' start and end dates. Some of these dates will overlap with other activities on the same project. I'm trying to figure out a way for Excel to total the number of days in a month spent on a given project, excluding overlapping days. In my attached example, the number of days in October for Project 1 would be 7 (including the start date), November would be 24 (Nov 1-21 & 28-30), and December would be 4. Can anyone help me out?

Book1.xlsx