One way would be to make a table,
AA1:AA12 = January through December
AB1:AB12 = February through January
Then sort the table alphabetically ascending on column AA,

Then use:

=VLOOKUP(A1,$AA$1:$AB$12,2,TRUE) in D1 and copy over to G1, etc.

Vaya con Dios,
Chuck, CABGx3



"Rich Hayes" wrote:

Hi

If in cell A1 I have a month name for example: 'January'

In cell D1 i want to say, if the month in cell A1 says 'January' then add a
month and show 'February' in cell D1 and so on so that in cell G1 i want to
say if cell D1 shows 'February' then add a month and show 'March' in cell G1.

The first month won't always be January!

Is this possible?

Many thanks

Rich