Populate 120 cell column with successive months entering only firs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
in A1 enter the start date
in a2 enter =DATE(YEAR(a1),MONTH(a1)+1,1)
copy a2 to a3 down to a120
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top