Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding months.
I need to set up a string of dates. How can I do this so that if i change
the first month all the following months change as well? If I enter a date in cell A1 and then type "=A1+1" in cell B1 one day is added to the date. I want to add one month. Please help!! |
#2
|
|||
|
|||
=date(Year*A1),MONTH(A1)+1,day(a1))
although this doesn't work if the day is greater than the nextmonth has, eg 31st Jan. -- HTH RP (remove nothere from the email address if mailing direct) "majech" wrote in message ... I need to set up a string of dates. How can I do this so that if i change the first month all the following months change as well? If I enter a date in cell A1 and then type "=A1+1" in cell B1 one day is added to the date. I want to add one month. Please help!! |
#3
|
|||
|
|||
The Analysis Toolpack add-in adds some date functionality. If you have the
Analysis Toolpack add-in installed, you can type "=edate($a$1,1)" in cell B1. This increments the month by 1. "majech" wrote: I need to set up a string of dates. How can I do this so that if i change the first month all the following months change as well? If I enter a date in cell A1 and then type "=A1+1" in cell B1 one day is added to the date. I want to add one month. Please help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add months and adding partial monhts | Excel Worksheet Functions | |||
Converting months to years | Excel Worksheet Functions | |||
how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
adding only positive numbers | Excel Discussion (Misc queries) |