In Between Dates

[Kumar]

I have a Travel Report Which Contains List of Employees who travels from
Place to Place with From and To Dates...Now i want to Know if an Employee
Travels for Ex:

ABC 11-04-2008 16-04-2008
ABC 13-04-2008 14-04-2008
ABC 15-04-2008 16-04-2008
He Should not Claim from 13/04/08 & 15/04/08 as he has already Claimed from
11/04/2008 to 16/04/2008 .So I need to wheather any Employee Claims in
between The Dates where he has already Claimed... Pls Help me ... Thanks in
Advance...

 

[Bernie Deitrick]

Kumar,

Assuming that your employees are in column A, and dates in B and C, starting in row 2, enter this in
D2, and copy down:

=IF(COUNTA(A2:C2)=3, IF(SUMPRODUCT(($A$2:$A$100=A2)*((($B$2:$B$100<=B2)*
($C$2:$C$100>=B2)+($B$2:$B$100<=C2)*($C$2:$C$100>=C2))>=1))<>1,"Overlap!",""),"")

Take out any line breaks that your software may put in - it should be all on one line...change the
100 to the row # of your last row of data.


HTH,
Bernie
MS Excel MVP