With a date in A1 put this in A2 and drag down. Format the same as A1

=IF(A1<"",DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"")

Mike

"Bonnie" wrote:

I am attempting to create a column in which the user can enter in the month
and year in the first row and the next 11 consecutive rows will reflect the
following sequential 11 months. e.g., Cell A1 has "Mar-07" entered, Cell A2
should automatically read "Apr-07", Cell A3 should automatically read
"May-07", etc.
--
Thank you for your time and effort in replying to my question.

Bonnie