In Between Dates
 

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...

In Between Dates
 

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


"Kumar" wrote in message
...
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...