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