Cell to calculate when another cell date is expired or close to expiring

[Muzza86]

Basically to keep it simple. I have 3 cells.

a1 has the formula =TODAY(-30) to show todays date(minus 30 days - so basically a month behind)
a2 is an expiry date for e.g. 24/08/2014
a3 needs to say "yes" or "no" to make it obvious to the end user that if the expiry date is within 30 days of expiring


what do I put in the formula for a3 , because whatever I seem to do it doesn't work. both cells are date format

[Jonmo1]

Try

=IF(TODAY()>=A2-30,"yes","no")

[Kaper]

A1:

Please Login or Register  to view this content.

a2 -> make sure it's date (may be not?) in B2:

Please Login or Register  to view this content.

is it right?

In A3:

Please Login or Register  to view this content.

[Vikas_Gautam]

try this..
I think this is more logical..

Please Login or Register  to view this content.

Don't forget to click *

[Kaper]

Hi Vikas,

Why you think that
A2-Today())<=30

Let's write it symbolically:
a-b<=c
(which can be written as
a-b<=c |+b-c
a-b+b-c<=b +c -c
a-c<=b
and of course swapping left/right sides
b>=a-c)

is more logical than
TODAY()>=A2-30

b>=a-c