W
WH99
Cell A1 has date Apr-08.
In cell A2, how can I add 1 month to A1 to read May-08.
In cell A2, how can I add 1 month to A1 to read May-08.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
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
=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
W
WH99
In that case I would need EOMONTH formula to give me the end of each month.
W
WH99
Just worked it out.
=EOMONTH(A2,1)
That adds one month to cell A2 plus gives the end of the month.
=EOMONTH(A2,1)
That adds one month to cell A2 plus gives the end of the month.
F
Fred Smith
Why do you need the end of the month when your format show only month-year?
Regards,
Fred.
Regards,
Fred.
W
WH99
Its a total for the whole month therefore I need it to include 1 to the end
of the month.
of the month.
R
Rick Rothstein \(MVP - VB\)
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
**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
P
Pete_UK
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
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