Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increase a date by 1 month | New Users to Excel | |||
Calculating Annual % Increase that occurs mid month | Excel Worksheet Functions | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) |