Thread: adding a month
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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