| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add one Month in the next cell for several months/years
I want to add a month in the next cell over for several years. EX: In cell
A1 is Dec 2005. In cell B1 I want Jan 2006 and so on for several months/years. When you put in a formula of =A1+31, eventually it will put in the wrong month. I assume because of Leap Year. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need cell formula to subtotal gross by month for a quarter | Excel Discussion (Misc queries) | |||
| How to Copy the value of a cell to any given cell | Excel Discussion (Misc queries) | |||
| Cell color based upon cell value | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| Change Cell Color if in current Month | Excel Worksheet Functions | |||
Threaded Mode
