adding a month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
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)
 
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.
 
Back
Top