Changing cell if within 365 days?

  • Thread starter Thread starter KrisP
  • Start date Start date
K

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!
 
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.
 
Fantastic! Thanks, thats spot on.

JLatham said:
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.
Click to expand...
 
Back
Top