Hi

Here the information you required, sorry can't seem to get the
attachment to work but here the info below:-

(A1) 01/04/2005
(A2) 31/03/2006

(E1) 04/07/2005
(F1) 00/01/1900
(G1) 04/07/2005

(in G1 =E1+F1)
(in H1 =IF(OR(G1<A1,G1<A2),"X","Y")

If no date has been input or 00/01/1900, it will come up an "X", how do
we stop this, only for when a date is input?

Hope this make sense to you?

Craig

P.S. i have other info to ask u but just wanna see if ok with u 1st


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=561089