Excel 2003 - Increasing a Date by 30
-
- StarLounger
- Posts: 82
- Joined: 17 Feb 2010, 20:26
- Location: Pittsburgh, PA
Excel 2003 - Increasing a Date by 30
Hello Everyone - I have a spreadsheet with a Date column. I want to increase the date, every 30 days for the remaining rows. I have attached an example. Any suggestions?
You do not have the required permissions to view the files attached to this post.
DaveInPitt
Pittsburgh, PA
Pittsburgh, PA
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: Excel 2003 - Increasing a Date by 30
That's not every 30 days. Do you mean you want the month to increase by 1? If so:
=DATE(year(A1),month(A1)+1,day(A1))
in A2 (assuming first data in A1) and copy down as required.
=DATE(year(A1),month(A1)+1,day(A1))
in A2 (assuming first data in A1) and copy down as required.
Regards,
Rory
Rory
-
- StarLounger
- Posts: 82
- Joined: 17 Feb 2010, 20:26
- Location: Pittsburgh, PA
Re: Excel 2003 - Increasing a Date by 30
Thanks Rory, yes, you are correct I want to increase the Month by 1. Does A1 represent the cell number?
DaveInPitt
Pittsburgh, PA
Pittsburgh, PA
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: Excel 2003 - Increasing a Date by 30
Yes, A1 is whichever cell has the first date in.
Regards,
Rory
Rory