Prev: Lists not working w/ userform
Next: Choosing a drop-down menu selection returns value to another c
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<N3),1,0)

--
Gary''s Student - gsnu201001


"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.
 | 
Pages: 1
Prev: Lists not working w/ userform
Next: Choosing a drop-down menu selection returns value to another c