(Solved) Looking to Auto-Populate Future Date Based On Conditional Variable

Hi There!

I was wondering if it would be possible to auto-populate a future date based on a variable from another cell.
For example I have the following data:

Frequency	Date Seen Last	Date Seen Next
Q2	01/01/20	---
Q4	01/01/20	---

My question is: Can I populate the third column...with a future date based on the date in the second column...with the future date's range being based on the list value from the first column.

So for example, Q2 is referencing that the client needs to be seen in 2 weeks while Q4 is referencing that a different client needs to be seen in 4 weeks (These values are restricted based on a list). Is there a formula I could put into the third column to automatically choose the correct future date based on a value (again, from a restricted list) listed in the first column? So that it looks like this:

Frequency	Date Seen Last	Date Seen Next
Q2	01/01/20	01/15/20
Q4	01/01/20	01/29/20