I have it like this
In column A is start of holidays
In column B is end of holidays
(one date written in A and one in B, and so on)
In C and D columns are start and end dates
Now I would like to check if start and and end dates of holidays, are between those dates in C and D
Quote22/05/2006 24/05/2006
Quote23/05/2006 24/05/2006
Check if first range of dates is between second one
Actually if holidays are between start and end date then check how many days are actually holidays in range of start and end dates
Kinda hard to explain
any Ideas maybe I am lost
thnx