Month+1
 

Cell A1 has date Apr-08.
In cell A2, how can I add 1 month to A1 to read May-08.
--
WH99

Month+1
 

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

Month+1
 

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

Month+1
 

Just worked it out.
=EOMONTH(A2,1)
That adds one month to cell A2 plus gives the end of the month.
--
WH99


"WH99" wrote:

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

Month+1
 

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

Month+1
 

Its a total for the whole month therefore I need it to include 1 to the end
of the month.
--
WH99


"Fred Smith" wrote:

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

Month+1
 

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

Month+1
 

Well said, Rick. I don't like to recommend any formula that relies on
the ATP being installed, because you can't guarantee this to be the
case (I never understood why MS didn't incorporate them into Excel
versions 2000 - 2003, though I understand they have done for 2007).

Pete

On Jun 28, 5:30*pm, "Rick Rothstein \(MVP - VB\)"
wrote:
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- Hide quoted text -

- Show quoted text -