In this article, we will learn how to add months and years to date. To add any number of months to a given date we will use EDATE.
EDATE function in excel returns a serial number of a future date after adding number of months to a given date.
Start_date: the date to which you want to add months.
Num_of_months: The number of months you want to add to start date.
So without fussing into words lets see an example.
For this example, I have this data. In cell A2, there is a start date, in B2 number of months to add and in C2 we will write the formula for adding months to this date.
Write this formula in C2
This will return the serial number of date which is not much readable for a normal user.
To make it readable, change the text format of cell C2 to date. You can copy the format from cell A2 and paste it on C2. Whichever way you like, you do it yourself.
Finally, you’ll have this readable future date.
To subtract months just add a minus sign before the number of months,
As we all know, each year has 12 months in it. So that’s it. In EDATE function, at the place of num_of_months write the number of years and multiply it by 12.
For example, if I want to add 2 years to Friday, August 02, 2019 I will write this formula to add years in excel.
The same goes for subtracting years from a date.
So yeah guys, we can add or remove months and years from a date in excel using the excel EDATE function. If you have any doubts, let me know in the comments section below.
How to Get days between dates in Excel
How to Calculate years between dates in Excel
How to Get Month From Date in Excel
How to Calculate Months Between dates in Excel
How to Convert Date and Time from GMT to CST in Excel
How to Get Month name from Date in Excel
How to Calculate days, years and months from certain date in Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.