Hi,

I have a different set of date ranges in excel column wise. If a date range comes between any of the other date ranges then the difference (removing Saturday & Sunday) between the particular date range should be zero.

example :
Range 1:
A Col : 01-Oct-2014
B Col : 06-Oct-2014

Range 2:
C Col : 08-Oct-2014
D Col : 15-Oct-2014

Range 3:
E Col : 03-Oct-2014
F Col : 05-Oct-2014

Range 4:
G Col : 16-Oct-2014
H Col : 16-Oct-2014

Then the difference between
Range 1 is 3 days
Range 2 is 6 days
Range 3 is 0 days
Range 4 is 1 days

Here Range 3 comes between Range 1 hence the difference should be zero.

I have nearly 50 columns and 4000 rows along with date and time. In few cases, date ranges may not be available.

For me it is very difficult to calculate. Please help me. Thanks in advance!



Regards,
Raja K