Why do you need the end of the month when your format show only month-year?

Regards,
Fred.

"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