Forum Discussion
Creating a fictious period of time without overlapping periods of time
Dear, For a large project I am experiencing some trouble in managing to create a fictious period of time based on several rows of dates. I manage to create the period manually or when the period ...
This is an example of the format in Excel, I can not upload a test file unfortunately.
I hope the next formula helps you. you have to analize the overlaping dates and substract from the result
A somewhat unusual approach on my part. First put all the days in a list and then delete the duplicates or multiples and then count them.
=COUNT(UNIQUE(VSTACK(SEQUENCE(B2-A2+1,1,A2),SEQUENCE(D2-C2+1,1,C2),SEQUENCE(F2-E2+1,1,E2))))
