formulas/function craig[ at ]help <craighelp.2aqezc_1152538877.4619[ at ]excelforum-nospam.com> 10.07.2006 13:32:51 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(a1>b1,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 :confused: -- craig[ at ]help ------------------------------------------------------------------------ craig[ at ]help's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36201 View this thread: http://www.excelforum.com/showthread.php?threadid=559884

Re: formulas/function Casey <Casey.2aqr92_1152554693.2743[ at ]excelforum-nospam.com> 10.07.2006 18:03:21 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?action=getinfo&userid=4545 View this thread: http://www.excelforum.com/showthread.php?threadid=559884