u/Altriss1

Please let me know if there's a better place for this question, I'm new to reddit.

I have to keep track of dozens of people various certifications. The date inputted is the date they got it. I want to format it so it's green unless:

In 9 months from today's date it turns yellow

In 11 months from todays date it turns red

I'd like to use the edate feature to account for monthly shifts, but the only formatting I've done were on actual expiration dates (using the greater than/less than feature), not future ones. Any suggestions or videos that would help?