Excel help please

Latest Articles

Excel help please

Downsizer Forum Index -> IT Matters

Author

Message

sgt.colon

Joined: 27 Jul 2009
Posts: 7380
Location: Just south of north.

Posted: Tue Dec 03, 13 10:59 am Post subject: Excel help please
Please can someone help me? I'm creating an Excel document and I want to set a date in a cell, Say E3 (05-01-2015) and then in the cell underneath, E4 have it pick up the date in cell E3 and then add 30 days to it to give me the next date. I then want to repeat the process for the rest of 2015, so E5, E6 and so on. Can anyone help with the formula? Thanks.

Nicky cigreen

Joined: 25 Jun 2007
Posts: 9967
Location: Devon, uk

Posted: Tue Dec 03, 13 11:15 am Post subject:

put the date in the first cell E3 - if necessary go to format and get the date arranged the way you like - if, for example, it was arranged the American way for dates - this might not be necessary

go to the cell underneath E4 and do a sum (E3+30)

it should come up with the date 30 days on

then highlight E4 and put your curser over the bottom right corner of the cell and, holding the left button of the mouse, drag the cells down for as many repeats as you want, when you let go it should fill in with the dates

sgt.colon

Joined: 27 Jul 2009
Posts: 7380
Location: Just south of north.

Posted: Tue Dec 03, 13 11:30 am Post subject:
Thank you Nicky, that's worked a treat. I was over complicating it by including DATE in my formula.

Midland Spinner

Joined: 13 Jan 2009
Posts: 2931
Location: Under a green roof

Posted: Tue Dec 03, 13 12:05 pm Post subject:
Can you do the opposite? i.e. put a two dates in and subtract one from the other to give you the number of days between? It's something I've always done by hand but it would help to be able to automate it.

Nicky cigreen

Joined: 25 Jun 2007
Posts: 9967
Location: Devon, uk

Posted: Tue Dec 03, 13 12:11 pm Post subject:

Midland Spinner wrote:

Can you do the opposite? i.e. put a two dates in and subtract one from the other to give you the number of days between?

It's something I've always done by hand but it would help to be able to automate it.

yes - just do it as a sum - in this example E4-E3

	Downsizer Forum Index -> IT Matters	All times are GMT
Page 1 of 1

View Latest Posts