From: Gator Girl on 22 Mar 2010 13:53 In cell m3 is 1/1/2010 in cell n3 is 4/1/2010. (the actual year will change every year) I want to say that if the date in cell z3 is between the date in M3 and the date in N3, return 1 I don't find a function for "between". HELP please. From: Roger Govier on 22 Mar 2010 14:00 Hi =IF(AND(Z3>=M3,Z3<=N�),1,"") -- Regards Roger Govier Gator Girl wrote:> In cell m3 is 1/1/2010 in cell n3 is 4/1/2010. (the actual year will > change every year) > > I want to say that if the date in cell z3 is between the date in M3 and the > date in N3, return 1 > > I don't find a function for "between". HELP please. From: Roger Govier on 22 Mar 2010 14:03 that should have read =IF(AND(Z3>=M3,Z3<=N3),1,"") -- Regards Roger Govier Roger Govier wrote:> Hi > > =IF(AND(Z3>=M3,Z3<=N�),1,"") > -- > Regards > Roger Govier > > Gator Girl wrote: >> In cell m3 is 1/1/2010 in cell n3 is 4/1/2010. (the actual year >> will change every year) >> >> I want to say that if the date in cell z3 is between the date in M3 >> and the date in N3, return 1 >> >> I don't find a function for "between". HELP please. From: Gary''s Student on 22 Mar 2010 14:21 if you want "between" to INCLUDE the end points: =IF(AND(Z3>=M3,Z3<=N3),1,0) if you want "between" to EXCLUDE the end points: =IF(AND(Z3>M3,Z3 In cell m3 is 1/1/2010 in cell n3 is 4/1/2010. (the actual year will > change every year) > > I want to say that if the date in cell z3 is between the date in M3 and the > date in N3, return 1 > > I don't find a function for "between". HELP please.  |