July 22, 2024


Welcome to the core

Adding years, months or days to a date

This will allow you to add years,months or days to a date in excel
Formula Type
 =DATE(YEAR(A2)+2,MONTH(A2),DAY(A2)) Years
 =DATE(YEAR(A3),MONTH(A3)+5,DAY(A3)) Months
 =DATE(YEAR(A4),MONTH(A4),DAY(A4)+6) Days
As seen in print screen below


Copyright © All rights reserved. | Newsphere by AF themes.