1

Topic: Intersection of intervals of dates

Good afternoon.
There are intervals of dates which can be intersected among themselves:
Date started, The Expiry date
01.07.2018, 16.07.2018
07.07.2018 , 20.07.2018
26.07.2018, 04.08.2018
15.08.2018, 30.09.2018
8/12/2018, 9/26/2018
It is necessary to calculate an amount of days in a month which do not get to one of these ranges:
Year, Month, In days
2018, 7 , 5
2018 , 8 , 10
2018 , 9, 0

2

Re: Intersection of intervals of dates

p_vadik;
The table a calendar, for it to superimpose the periods and restriction - which result of days is not present.
The one million first question....

3

Re: Intersection of intervals of dates

TaPaK wrote:

p_vadik;
The table a calendar, for it to superimpose the periods and restriction - which result of days is not present.
The one million first question....

Thanks for idea.
It so elementarily appeared)