How do I get 30 day advance notice to a work anniverary?

[Scott Hetzel]

I am using rounddown to determine how many years of service an emplyee has, but would like to be notified somehow prior, is there a way? I have attached the spreadsheet I am using.

Thanks

[#2]

Yes that works, thank you.

[#3]

@Scott Hetzel  In the attached I created a conditional formatting rule:

=MOD(TODAY()-$E1,365.25)>335

that should be good +/- a day

[#4]

I see you relied to yourself "that works". What worked?

[#5]

@Scott Hetzel 

=DATE(YEAR(E2)+ROUNDDOWN((TODAY()-E2)/365,0)+1,MONTH(E2),DAY(E2)-30)

Maybe with this formula.