Formula to Select the Nth day of every month based on the value of a cell

[mysticmoron109]

Hello All,

I am looking to create a payment schedule with varying dates of the month.

The normal payment cycle is as follows:

1st payment due on date the invoice is raised, i.e., today.
Recurring payments scheduled on an agree-upon date for an agree-upon number of months. First payment being due on the following month after the date of initial invoice.

I have attached a spreadsheet to give a vague representation of what I am after.

Basically I want a formula that will take whatever date i Have input under "payment date" and select that same date for the forthcoming months (number of months indicated under "Recurring payments") and input that date in the "Payment Dates" column.

Any help is greatly appreciated!

Thank you!!!!!

[ChemistB]

In E3 copied down
=EDATE(E2,1)
Is that what you wanted?

[CAntosh]

I might be wrong, but it looks like you'll need a few conditions to cover you when your invoices change. I think if you copy the formula below into E3 and fill down through column E (and up to E2), you'll be able to ignore column E going forward. It'll pull the E column date from your other data, regardless of whether it's the first month or one of the subsequent payments.

=IF(ISBLANK($D3),IF(ISBLANK($D2),DATE(YEAR($E2),MONTH($E2)+1,DAY($E2)),DATE(YEAR($E2),MONTH($E2)+1,DAY($D2))),$B3)