Forum Discussion
BonoTenere
Feb 11, 2023Copper Contributor
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 ...
BonoTenere
Feb 11, 2023Copper Contributor
This is an example of the format in Excel, I can not upload a test file unfortunately.
roder_01
Feb 11, 2023Copper Contributor
I hope the next formula helps you. you have to analize the overlaping dates and substract from the result