View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default FORMULA TO INCREMENT 25 MONTHS BASED ON A DATE CELL

SorianoP wrote:
I need to create a formula to increment the date on a column by 25
months on another column


Hi SorianoP,

try with this:

=DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))


where in A1 is your starting date and in A2 the number of months to add to
initial date.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy