If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Increase cell value by 1 month
What formula do I use to increase cells by 1 month?
i.e. If I have December 2009 in A1, how do I get Jan 2010, Feb 2010, etc. in A2, A3, etc.? |
#2
|
|||
|
|||
Increase cell value by 1 month
Melissa
One way is in cell A2 apply the below formula and copy down as required =DATE(YEAR(A1),MONTH(A1)+1,1) You can just type in 12/1/2009 in A1 and 1/1/2010 in A2 and select these cells and drag down to have each month in a cell. If this post helps click Yes --------------- Jacob Skaria "Melissa" wrote: What formula do I use to increase cells by 1 month? i.e. If I have December 2009 in A1, how do I get Jan 2010, Feb 2010, etc. in A2, A3, etc.? |
Thread Tools | |
Display Modes | |
|
|