Help with if function

[Greg B]

Sorry for another post but

I use this =IF(A2<NOW(),"yes","no")

How do I add a extra part to it it has to be in between the range of now()
and now()+14

How would I put that into the formula

Thanks again

Greg

 

[Chris Short]

IF(and(A2>NOW(),A2<NOW()+14), "yes", "no")

(you may want to use <= and >=, depending on your exact requirement.

Cheers,

Christopher

Sorry for another post but

I use this =IF(A2<NOW(),"yes","no")

How do I add a extra part to it it has to be in between the range of

 

[Bob Phillips]

Also, you probably want TODAY not NOW, as 03/03/2005 is less than NOW() but
equal to TODAY()

=IF(AND(A2>=TODAY(),A2<=TODAY()+14), "yes", "no")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Greg B]

Thanks again

The and function worked just right

Thanks Greg