View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
heater
 
Posts: n/a
Default 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.