• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Check if 2 date ranges overlap

Hi ,

A standard formula for calculating the overlap is :

=MIN(To_Date1,To_Date2) - MAX(From_Date1,From_Date2) + 1

where the two sets of dates are :

From_Date1 and To_Date1

From_Date2 and To_Date2

Narayan
 
Sorry, not perfect!
For some reason if I change the start date it recalculates correctly but changing the end date does not prompt the recalculation ?
 
Back
Top