Solved: adding a Month

[chungtinhlak]

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]

=A1+30
=A2+30

[Bob Phillips]

=DATE(YEAR(A1),MONTH(A1)+1,1)

etc.

or

=EOMONTH(A1,0)+1

[lucas]

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]

I had read it that all dates start on 1st, so I always used day 1.

[lucas]

I thought he meant one month from the date in A1. Clarification would help wouldn't it?

[Bob Phillips]

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]

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.