Good Morning All,
I have a sheet where I need to track 10 years after a date to show that it expires. Currently, I have 2 formulas (listed Below) however once it hits the 10-year mark it turns red and then the next day it goes back to the other format and turns back to orange 1 day after my end date. Again I'm sure its something simple that I am missing any help would be appreciated.
=AND(G2<>"",EDATE(G2,120)=TODAY()) This is first on the list and checked for "stop if True"
=AND(G2<>"",EDATE(G2,108)<=TODAY())
Thank you in advance,
I have a sheet where I need to track 10 years after a date to show that it expires. Currently, I have 2 formulas (listed Below) however once it hits the 10-year mark it turns red and then the next day it goes back to the other format and turns back to orange 1 day after my end date. Again I'm sure its something simple that I am missing any help would be appreciated.
=AND(G2<>"",EDATE(G2,120)=TODAY()) This is first on the list and checked for "stop if True"
=AND(G2<>"",EDATE(G2,108)<=TODAY())
Thank you in advance,