| 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) | |||
Linear Mode
