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

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

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)


"Chris Short" wrote in message
...
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

Thanks again

The and function worked just right

Thanks Greg