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

Occasional Contributor

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

4 Replies
Yes that works, thank you.

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

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

that should be good +/- a day

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

@Scott Hetzel 

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

Maybe with this formula.