View Single Post
  #3   Report Post  
LanceB
 
Posts: n/a
Default

or
in A1 enter the start date
In a2 =EOMONTH(a1,1)


Format cells as mmmm to see just the month


"LanceB" wrote:

in A1 enter the start date
in a2 enter =DATE(YEAR(a1),MONTH(a1)+1,1)
copy a2 to a3 down to a120


"2ndchinv" wrote:

I have a column of 120 cells I want to populate with successive months
repeating, of course, 10 times. The start month can be any month of the year.
I want to be able to enter only the start month and the rest of the column
will populate automatically with successive months.