Finding a date 10 years after and coloring it

[Dclark015]

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

 

[James006]

Hi,
Just remove the sign < in your formula:

=AND(H2<>"",EDATE(H2,120)=TODAY())

 

[Dclark015]

Hi,
Just remove the sign < in your formula:

=AND(H2<>"",EDATE(H2,120)=TODAY())

Perfect thank you very much. I knew it would be something easy have a great rest of your day!

 

[James006]

You are welcome