Hi Rich

In cell 1, enter 01/01/2005 but format the cell FormatCellsNumberCustom
mmmm so it displays as January
in D1
=DATE(YEAR(A1),MONTH(A1)+1,1)
Ensure formatting of D1 is the same as A1
Copy the formula to G1 etc. as required.

Regards

Roger Govier


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