IF Statement Required - if Date is greater than 12 months

[stevebrooks01]

Hi All,

In column A I have dates.

In column B I need a formula that says true of false if the date is greater than 12 months ago.

THANK YOU
Steve
UK

 

[jeffreybrown]

How about...

=IF(A2 < TODAY()-365,"Yes","No")

 

[al_b_cnu]

Hi Steve,

This caters for leap years:

=A2 < DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))

 

[Asala42]

How about:

=Today()>(EOMONTH(A2,11)+Day(A2))

 

[stevebrooks01]

i love each and every one of you

 

[al_b_cnu]

Steady on now!

 

[Jon von der Heyden]

Another way

=datedif(a1,today,"m")>12

I'm suggesting a name called 'today' which refers to today()

 

[stevebrooks01]

http://www.mrexcel.com/forum/showthread.php?p=2916686#post2916686

any ideas please Gentlemen?