Auto-fill dates based on input in other cells

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!

Copying formulae is okay, but is there a way to auto-populate the data? for example, if I insert the final date and close out date, the due date and reminders 1-3 will auto general based on a pre-determined formula?


Attached is a sample of my data sets. If you can't see the attachement, please let me know.

If it can only happen with VBA, that's fine. I wasn't sure if it was possible without VBA.

Sure! I appreciate your willingness to help.

So, in the example workbook, there's a final date of 03/31/2018. It has a 45 day close out. For all close outs of 45 days, I need to add 10 days to get the 1st reminder date. I add 30 days for the 2rd reminder date. For example:

Final Date: 03/31/2018
Close Out: 45 Days

03/31/2018 + 10 days = 04/10/2018 (1st reminder)
03/31/2018 + 20 Days = 04/20/2018 (2nd reminder)
03/31/2018 + 33 Days = 05/03/2018 (3rd reminder)
03/31/2018 + 35 days = 05/05/2018 (due date)

However, I can have the same final date, but with a different close out date. So, that data set would look like this:

Final Date: 03/31/2018
Due Date: 60 Days

03/31/2018 + 10 Days =04/10/2018 (1st reminder)
03/31/2018 + 30 Days =04/30/2018 (2nd reminder)
03/31/2018 + 40 Days =05/10/2018 (3rd reminder)
03/31/2018 + 42 Days =05/12/2018 (Due Date)

I ultimately need to take the input from the 03/31/2018 column and based on the 90 days column, populate the rest of the data. I know likely need to use an IF/THEN statement to do it, I'm just not sure of the syntax.

No, no, it's not you! It's a very fair question and regretfully something determined by someone else other than me. These are just the set "due" dates I have to work with.

That's alright. Thanks anyway for your help!

Okay, sorry to bug you again, but let's just pose the hypothetical that the due day in the example you highlighted WAS 45 days. Do you know of a way then to craft a VBA line?

You don't need VBA for this as I understand it, does the attached do what you're after?

What you aren't explicit about is what should happen should the reminder date fall after the due date