Excel - Automatically insert months

December 2016



Issue


I've created an Excel file where in column A1, I have a date (14/02/2000) and in B1 I have +120 (the number of months). I would like result in C1(Date in A1 + 120 months).
Is there any solution to avoid doing it manually?

Solution

  • C1=(DAY(A1)&"/"&MONTH(A1)+B1-INT(B1/12)*12&"/"&INT(YEAR(A1)+B1/12))*1 
  • C1 will be in the following format *14/03/2001

Related :

This document entitled « Excel - Automatically insert months » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.