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.