formulas/function craig[ at ]help <craighelp.2aqezd_1152538878.1773[ at ]excelforum-nospam.com> 10.07.2006 13:34:59 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 still show x '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=559885

RE: formulas/function Sloth 10.07.2006 14:33:02 =IF(ISBLANK(A1),"",IF((DATE(2005,1,1)<=A1)*(DATE(2005,12,31)>=A1),"X",IF((DATE(2006,1,1)<=A1)*(DATE(2006,12,31)>=A1),"Y","Out of Range"))) If your dates include times (example: 12/31/2005 4:30 PM), then you might need this formula... =IF(ISBLANK(A1),"",IF((DATE(2005,1,1)<=A1)*(DATE(2006,1,1)>A1),"X",IF((DATE(2006,1,1)<=A1)*(DATE(2007,1,1)>A1),"Y","Out of Range"))) "craig[ at ]help" wrote: [Quoted Text] > > 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 still show x > > '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=559885 > >

Re: formulas/function "Ardus Petus" <ardus.petus[ at ]laposte.net> 10.07.2006 15:14:57 IF(A1="","",IF(YEAR(A1)=2005,"X",IF(YEAR(A1)=2006,"Y"))) HTH -- AP "Sloth" <Sloth[ at ]discussions.microsoft.com> a écrit dans le message de news: 38066873-4181-44D8-BA49-24C4175136DC[ at ]microsoft.com... [Quoted Text] > =IF(ISBLANK(A1),"",IF((DATE(2005,1,1)<=A1)*(DATE(2005,12,31)>=A1),"X",IF((DATE(2006,1,1)<=A1)*(DATE(2006,12,31)>=A1),"Y","Out > of Range"))) > > If your dates include times (example: 12/31/2005 4:30 PM), then you might > need this formula... > > =IF(ISBLANK(A1),"",IF((DATE(2005,1,1)<=A1)*(DATE(2006,1,1)>A1),"X",IF((DATE(2006,1,1)<=A1)*(DATE(2007,1,1)>A1),"Y","Out > of Range"))) > > "craig[ at ]help" wrote: > >> >> 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 still show x >> >> '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=559885 >> >>