PDA

View Full Version : Solved: adding a Month



chungtinhlak
01-14-2009, 11:09 AM
Is there a way to just add a month to your day. I want to my first row to be the initial month and add a month to it until it get's to 12 months. This way, i only have to change the beginning. Example


A
1. 1/1/09
2. A1 + (one month)
3. A2 + (one month)

this way, I can go in and change cell A1 and verything else will shift a month.

Thanks

lucas
01-14-2009, 11:36 AM
=A1+30
=A2+30

Bob Phillips
01-14-2009, 11:38 AM
=DATE(YEAR(A1),MONTH(A1)+1,1)

etc.

or

=EOMONTH(A1,0)+1

lucas
01-14-2009, 11:40 AM
I guess that might be off a day or two. From the help file:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))

Bob Phillips
01-14-2009, 12:30 PM
I had read it that all dates start on 1st, so I always used day 1.

lucas
01-14-2009, 12:41 PM
I thought he meant one month from the date in A1. Clarification would help wouldn't it?

Bob Phillips
01-14-2009, 01:55 PM
I thought he meant one month from the date in A1. Clarification would help wouldn't it?

Wouldn't it always ... we battle on with our assumptions.

I answered a query today where the guy wanted to calculate the week number within the quarter of some date, so 5th Jan is week 1, and 3rd April would be week 1 also as it is a separate quarter. So I concocted a fairly complex formula to do so. Then another guy said, why not use WEEKNUM, and the OP said, yes that was perfect!

lucas
01-14-2009, 01:59 PM
I respect your tenacity Bob. Sometimes all I do in a thread is ask enough questions so that someone can help the poster.

I wish I could see over their shoulder as they sometimes seem to think we can.