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.



4 Replies
Yes that works, thank you.

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


that should be good +/- a day

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

@Scott Hetzel 


Maybe with this formula.