Select cells A1 thru A10 and:

Format Cells... Number Custom mmmm

In A2 enter:
=DATE(YEAR(A1),MONTH(A1)+1,1) and copy down

In A1 enter any date.
--
Gary''s Student - gsnu200841


"Dezzie" wrote:

Hello. I am creating an input area for another Excel user.

I would like A2:A10 to return the names of months in order, depending on
what month was in A1.

For example, if A1=January, then A2=February, A3=March, A4=April, etc.
But if A1=February, then A2=March, A3=April, A4=May, etc.

Is there a way to do this using IF and OR, or a simpler way?
As well, A1 is being chosen using a list. Does this complicate matters too
much, or can I leave it in? Thanks.
Thank you