PokerZan Wrote:
Ok, I think I have this figured out.

You will need a help column for each date "gap" you are looking to
measure. The first one will be (based on your example) in column K
starting with cell K2. Here is the formula for you.

=IF((C2-D2)1,"GAP",IF((C2-D2)<1,"OVERLAP",""))

This will put "GAP" where there is a gap of more than one day between
the "T1 Valid to" and the "T2 Valid From" fields, as well as return an
"OVERLAP" if the difference in days between the two dates are less than
1 day.

Just copy this column down the page and it should tell you where and
how you need to fix the data.

In Column L you would just change the "(C2-D2)" to "(E2-F2)".

Hope this helps.

PZan


Is there anyway we could use one formula and get the same info for T1,
T2, T3, T4? I tried above formula, which is good.

Thank you so much.


--
xgunda420x
------------------------------------------------------------------------
xgunda420x's Profile: http://www.excelforum.com/member.php...o&userid=25559
View this thread: http://www.excelforum.com/showthread...hreadid=389953