I want formula which will tell me that T2 Valid from and T2 Valid to has
wrong date or give me a return value which will tell me that this row
has wrong date so I could get estimate # of how many dates I have to
fix.

This is the problem, and probably why you aren't getting a response.

How are you (or we) going to determine what is a "wrong" date? Are
there set rules for what constitutes a "valid" date? Is the "Valid to"
date a set number of years/months/days from the "Valid from" date? If
you can provide a bit more information as to what would make a date
"wrong" or "right" it would prolly hasten your answer/help. :)

PZan


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