Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add one month to the previuos month
I am setting up an amortization table and want to add one month to the
previous month: Ex: b9 has the start date 12/1/04 b15 needs to be the next month Jan 05 b16 Feb 05 and so on for 10 years The problem comes in 2007 (must be a leap year) it skips a month and throughs the whole thing off. |
#2
|
|||
|
|||
Try this formula in B15: =EOMONTH(B9,0)+1
.... and then this one in B16: =EOMONTH(B15,0)+1 You may need to format these as dates. The EOMONTH() formula determines the last day of the month; adding one yields the next day, or the first day of the next month. |
#3
|
|||
|
|||
Heater,
In B15, enter the formula =DATE(YEAR($B$9),MONTH($B$9)+ROW()-14,1) And fill down as far as you need. HTH, Bernie MS Excel MVP "heater" wrote in message ... I am setting up an amortization table and want to add one month to the previous month: Ex: b9 has the start date 12/1/04 b15 needs to be the next month Jan 05 b16 Feb 05 and so on for 10 years The problem comes in 2007 (must be a leap year) it skips a month and throughs the whole thing off. |
#4
|
|||
|
|||
Hi
You could enter 1/1/05 in B15 then right click on the fill handle at the bottom right of the cell and drag down for the range required. When you release the right mouse button, choose Fill Months. -- Regards Roger Govier "heater" wrote in message ... I am setting up an amortization table and want to add one month to the previous month: Ex: b9 has the start date 12/1/04 b15 needs to be the next month Jan 05 b16 Feb 05 and so on for 10 years The problem comes in 2007 (must be a leap year) it skips a month and throughs the whole thing off. |
#5
|
|||
|
|||
On Wed, 9 Feb 2005 10:19:03 -0800, heater
wrote: The problem comes in 2007 (must be a leap year) it skips a month and throughs the whole thing off. How are you doing this? By the way, 2007 cannot be a leap year. --ron |
#6
|
|||
|
|||
And one more formula, which I use because it's more intuitive to me:
=date(year(b9),month(b9)+1,day(b9)) -- Regards, Fred Please reply to newsgroup, not e-mail "heater" wrote in message ... I am setting up an amortization table and want to add one month to the previous month: Ex: b9 has the start date 12/1/04 b15 needs to be the next month Jan 05 b16 Feb 05 and so on for 10 years The problem comes in 2007 (must be a leap year) it skips a month and throughs the whole thing off. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
UserForm to select current month or earlier | Excel Discussion (Misc queries) | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
PivotTable - Count by Month | Excel Worksheet Functions |