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

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
--
David Biddulph

"BorisS" <(E-Mail Removed)> wrote in message
news75FFCD1-50A1-400D-A73E-(E-Mail Removed)...
> 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

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

Hi Boris

If the day of the month in the starting cell is always going to be less
than29, then
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))

If it is always going to be the last day of the month, then use
=DATE(YEAR(A1),MONTH(A1)+2,0)

--
Regards
Roger Govier



"BorisS" <(E-Mail Removed)> wrote in message
news75FFCD1-50A1-400D-A73E-(E-Mail Removed)...
> 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

To add 1 month, but cater for that month having less days and not
over-spilling,

=MIN(DATE(YEAR(A1),MONTH(A1)+{2,1},DAY(A1)*{0,1}))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"BorisS" <(E-Mail Removed)> wrote in message
news75FFCD1-50A1-400D-A73E-(E-Mail Removed)...
> 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

Another method is to use the 'EOMONTH(A1,1)' option?
--
Regards


"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

The answer to your question is "No". I think you need to look at Excel help
to remind yourself what EOMONTH does. It doesn't do what the OP asked for.
--
David Biddulph

"Karver" <(E-Mail Removed)> wrote in message
news:97A025A9-5597-4917-9845-(E-Mail Removed)...
> Another method is to use the 'EOMONTH(A1,1)' option?

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