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.