Good Afternoon,
I am working on a spreadsheet and I am trying to get the conditional formatting to work correctly. I am using =AND(H2<>"",EDATE(H2,120)<=TODAY()) to find a date 10 years after 3/5/2013 and once that date of the sheet hits 10 years I want it to turn red. Im also building one that would turn orange at 9 years to warn that its getting ready to expire.
This formula works but the date turns red on the first day of 2023 and not the specific date after 3/5/2013. I'm sure that Im missing something and could use the help.
Thanks all
I am working on a spreadsheet and I am trying to get the conditional formatting to work correctly. I am using =AND(H2<>"",EDATE(H2,120)<=TODAY()) to find a date 10 years after 3/5/2013 and once that date of the sheet hits 10 years I want it to turn red. Im also building one that would turn orange at 9 years to warn that its getting ready to expire.
This formula works but the date turns red on the first day of 2023 and not the specific date after 3/5/2013. I'm sure that Im missing something and could use the help.
Thanks all