Hello everyone.
I hope I can be clear enough about my question to get it solved. I'm looking for either a formula (or VBA code if a formula doesn't exist) to auto-generate dates based on input in one cell and based on the date in another. Here's an example of my relevent data.

So, there are 4 types of closeout dates: 30 days, 45 days, 60 days, and 90 days. Depending on the close out dates, this affects the due date and reminders 1-3.
Is it possible write a preset formula that takes the data from the final date column and the closeout column to populate due date and reminders 1-3? So far I've just been typing in the cell =d2+10, for example, to get reminder 1 and =d2+20 to get reminder 2, etc. I'd like to not have to type this for each instance.

Final Date Closeout Due Date Reminder 1 Reminder 2 Reminder 3
03/09/18 30 Days 03/29/2018 03/14/2018 03/24/2018 03/27/2018
03/11/18 90 Days 05/15/2018 03/21/2018 04/20/2018 05/25/2018
03/13/18 90 Days 05/17/2018 03/23/2018 04/22/2018 05/27/2018
03/19/18 90 Days 05/23/2018 03/29/2018 04/28/2018 06/02/2018
03/26/18 90 Days 05/30/2018 04/05/2018 05/05/2018 06/09/2018
03/30/18 60 Days 05/11/2018 04/09/2018 04/29/2018 05/09/2018



Thank you!