between

G

Gator Girl

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.
 
G

Gary''s Student

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top