Jun 03 2022 12:17 PM
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
Jun 03 2022 01:03 PM
Jun 03 2022 01:11 PM
@Scott Hetzel In the attached I created a conditional formatting rule:
=MOD(TODAY()-$E1,365.25)>335
that should be good +/- a day
Jun 03 2022 01:12 PM