Hi there!

Im wondering if you could help me out as im trying all kind of tricks
to make what i want it to work, i have tried =if(or(a1b1,a1<b2),
"x","y") function, (b1=01/01/2005, b2= 31/12/2005) it will work but if
no date has been input then it I

'm looking for fornulas/function that will help me with my work, see
below:
between 01/01/2005 and 31/12/2005 = "x"
between 01/01/2006 and 31/12/2006="Y"
if no date input then ignore it or leave it blank.

I would be grateful for your kind support.

Craig



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

Try:

=IF(AND(YEAR(B1)=2006,YEAR(B2)=2006),"x",IF(AND(B1 <"",B2<""),"y","At
least one date is missing"))

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=559884