Monthly dates formula

I like to create the following:

cell A1 =1/2007 (results Jan-07)
cell A2 =(A1+31) (results Feb-07
cell A3 =(A2+31) (results Mar-07)

It works most of the time but it misses a month here and there (I think it has to do with the 31 days).

Is there an easy way to do this without the 31 days?

Bruce

Another option is to type 1/1/2007 in the first cell, 2/1/2007 in the second cell, highlight both cells, then drag the lower right corner, and it will auto fill.

HTH

Jason

OK, I added the Analysis Toolpak and inserted the following:


A1 = 1/2007 (displayed as Jan-07)

A2 =EOMONTH(A1,0) displayed as Jan-07

A3 = need formula to display Feb-07

Thanks for your help.

Bruce

Note: I just want to insert the 1/2007 in one cell and have the other cells fill themselves out.

If you always put the first of a month in A1 then rather than EOMONTH, try using EDATE. In A2 copied down as far as you require

=EDATE(A1,1)

Now if you change A1 all the others will change automatically.

An alternative without Analysis ToolPak

=A1+32-DAY(A1+31)

The =EDATE(A1,1) did the trick.

Thanks.

Bruce