The formula in the yellow highlighted cell in the attached is long and was wondering if there is an array formula that can do the same thing.
Basically, I am trying to determine the total days from each of the periods in orange will fall into the period in blue.
Thanks in advance.
Bookmarks