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.
|