Excel Formula that only returns less than 5 working days from today()

[williamthomp]

I know this should be simple but cant figure out how to have a cell return "Yes" or "No" when the cell selected is less than 5 days from todays date. What I keep getting is anything within 5 days including things after todays date or anything greater than 5 days..I need it to only return the responses if it is within the 5 day time frame

=IF((AND($A3>TODAY(), $A3-TODAY()<=5)),"Yes","No")

thanks

[Fluff13]

How about

Please Login or Register  to view this content.

[Sam Capricci]

how about ...
=IF(TODAY()-5<A3,"yes","no")
or, since that will return yes for greater than today this will leave a blank for that...
=IF(A3>TODAY(),"",IF(TODAY()-5<A3,"yes","no"))

[williamthomp]

Yes..thanks that works..How do I tweek it where it also allows for today also be a "Yes"

[Sam Capricci]

which post are you referring to? Mine shows today as yes.

[Fluff13]

If you're referring to my formula
=IF(AND(A5 >TODAY()-5,A5 <= TODAY()),"Yes", "no")

and thanks for the rep