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)) ]