6. Add Month to or Subtract Month from a Given Date
Very often, you will have business problems where you have to add or subtract month
from a given date. One scenario is calculation for EMI Date.
Say, you have a date of 10/22/14 (MM/DD/YY) in A1 and you want to add number of
months which is contained in Cell B1.
The formula in this case would be
=EDATE(A1,B1)
[Secondary formula =DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1)) ]
Now, you want to subtract month which is contained in Cell B1.
=EDATE(A1,-B1)
[Secondary formula =DATE(YEAR(A1),MONTH(A1)-B1,DAY(A1)) ]
7. Add Year to or Subtract Year from a Given Date
In many business problems, you might encounter situations where you will need to add or
subtract years from a given date.
Let's say A1 contains Date and B1 contains numbers of years.
If you want to add Years to a given date, formulas would be -
=EDATE(A1,12*B1)
=DATE(YEAR(A1)+B1,MONTH(A1),DAY(A1))
