Changing cell if within 365 days?

[KrisP]

Hi,
I need a way of changing the text in a cell if its over 365 days from a date
in a cell A1?

Example - If A1 is 01/06/2008 then cell B2 = yes. If A1 was 01/01/2000 then
B2 = no.

Thanks in advance!

 

[JLatham]

Try a formula such as this in B2
=IF(NOW()-A1>365,"Yes","No")

If the date in A1 is more than 365 days in the past, "YES" will appear, but
if it's within the past 365 days, "NO" will appear.

 

[KrisP]

Fantastic! Thanks, thats spot on.

Try a formula such as this in B2
=IF(NOW()-A1>365,"Yes","No")

If the date in A1 is more than 365 days in the past, "YES" will appear, but
if it's within the past 365 days, "NO" will appear.