First off, you do realize that you never mentioned that you wanted the
**end** of the next month in your original question, right? Pete gave you
the answer to the question you asked. While you can certainly use the
EOMONTH function if you want, it is not necessary to do so. If you had said
you wanted the end of the next month in your original posting, I'm sure Pete
would have posted this formula for you instead...

=DATE(YEAR(A1),MONTH(A1)+2,0)

Rick


"WH99" wrote in message
...
In that case I would need EOMONTH formula to give me the end of each
month.
--
WH99


"Pete_UK" wrote:

Use this in A2:

=DATE(YEAR(A1),MONTH(A1)+1,1)

and copy down. This will give you the 1st of the month as the
underlying date, but if you want the same day as in the first date you
can modify it to this:

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

The problem with this is if your first date is the 30th or 31st of a
month and subsequent months have fewer days.

Hope this helps.

Pete

On Jun 28, 11:34 am, WH99 wrote:
Cell A1 has date Apr-08.
In cell A2, how can I add 1 month to A1 to read May-08.
--
WH99