Excel - Automatically insert months

May 2017



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


Published by aakai1056. Latest update on June 18, 2012 at 06:20 AM by aakai1056.
This document, titled "Excel - Automatically insert months," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).