Try a formula such as this in B2
=IF(NOW()-A1365,"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" wrote:

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!