Excel - Automatically insert months

April 2018



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?
  • 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
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 (https://ccm.net/).
Excel - Color cells on condition
Excel - Display a value when specific name is entered