Because they have been completed within the last 365 days. I am trying to get the cells to change colors based on when their anniversity date is.

Ok the system that we have is you will enter the certificate date, they are good for one year. Therefore, I need the dates to change colors when it approaches for them to be renewed.