Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

Expired

£0.00 @
Hi Can't work this out, and I know I should be able to do so. I have customers that pay me once a month, for 3 months. All I want is to be able to enter the first payment (example - 17th Dece… Read More
banned2y, 5m agoPosted 2 years, 5 months ago
Hi

Can't work this out, and I know I should be able to do so.

I have customers that pay me once a month, for 3 months.

All I want is to be able to enter the first payment (example - 17th December 2014), then the next 2 cells will automatically fill with 17th Jan 2015, and 17th Feb 2015.

I'm know I'm just being thick, someone please put me out of my misery please. It's been an awful long day.
banned2y, 5m agoPosted 2 years, 5 months ago
Options
in 1st cell e.g. A1, enter the date you want i.e. 17th Dec 2014
in following cell, enter the following formula "=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))"

In place of just placing 1 in the bolded section above, you can reference to another cell to add X number of months to customise it further.

## All Responses

(3)
Responses/page:
banned#1
Gonna answer my own question here, as it was more complex than I realised.

Type "=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))" without quotes in a blank cell, replacing "A1" with the reference to the cell containing the date. In this example, the date in cell "A1" will increment by one month.
#2
in 1st cell e.g. A1, enter the date you want i.e. 17th Dec 2014
in following cell, enter the following formula "=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))"

In place of just placing 1 in the bolded section above, you can reference to another cell to add X number of months to customise it further.
#3
In first cell, type the first date, in the next cell type the second date. Then highlight both cells, take the cursor to the bottom right corner and replicate across.