Excel spreadsheet help - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

#### Search Error

An error occurred when searching, please try again!

Expired

# Excel spreadsheet help

banned1y, 10m agoPosted 1 year, 10 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.
banned1y, 10m agoPosted 1 year, 10 months ago
Options
Best Answer
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.

## Post an Answer

You don't need an account to leave a response. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!