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

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

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!!!!!

2. ## Re: Formula to Select the Nth day of every month based on the value of a cell

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

3. ## Re: Formula to Select the Nth day of every month based on the value of a cell

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)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1