adding a month
Maybe:-
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
Mike
"BorisS" wrote:
what's the simplest formula to add exactly a month to the next cell of a
series? In other words, enter a beginning date, and then have the formula
next to it take that date and add one month. Thanks.
--
Boris
|