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

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

Cheers,

Christopher

"Greg B" wrote in message
...

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

"Greg B" wrote in message
...
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