Hello, I am trying to use Icon sets in Excel
to show when a certificate has expired based on the completion date. I have multiple Certificates that have different renewal dates e.g First Aid every 3 years, Safeguarding every 2 years
For example,
Someone completed their First Aid Certificate on 14/07/2023. The certificate lasts three years I want to use Icon sets to show when the certificate is:
In date (green) where there are 1095 days or more left on the certificate
Expiring (Yellow) when there are only 90 days left
Expired (Red) when 0 days left.
I am using the Today() formula, but it doesn't seem to work fully.
Is this possible?
Bookmarks