Hi, I have a table that looks like this:

    Column A                  Column B

1    Risk Level                     A                 

2    Date Submitted            12/18/20

3    Next Audit Date            ?

I need to show automatically when the next audit due date is based off the risk level, and the date the audit was submitted. So if the level is "A", then I need the due date to be 3 years from the date submitted "12/18/20". I've tried an IF statement, and EDATE, but nothing works. 🙁

Any help is greatly appreciated

Marcy