View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rowan Drummond
 
Posts: n/a
Default additional month calculation

If you install the Analysis Toolpak addin you can use the Edate formula
which adds months to a date eg
=Edate(A1,1)

Hope this helps
Rowan

BorisS wrote:
I have a starter cell with a month/year. Is there a way other than
date(year(),month()+1,1) to get the following cell to just add one to the
month (and I need something that would continue for four years...I know that
month 13 of any year is the next year, so am figuring that might play into
this formula).

Thx.