Fresh Excel Tips

Let’s say we want to add a number of months to a given start date. In a new worksheet, list different start dates in column A. In column B, enter the number of months to be added to or subtracted from the start date. Based on that data, the end date can be calculated. Here is how we’ll do this:

How To add/subtract months to or from dates

1. In cells A2:A10 list some start dates.
2. List in cells B2:B10 the number of months to add or subtract.
3. Select cells C2:C10 and type the following formula: =DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2)).
4. Press CTRL+Enter.

To determine an end date in the past, put a minus sign in front of the number of months. This will work in Excel 97, 2000, 2003 and 2007.

1. How to Use the EDATE function to calculate months in Excel
2. How to Combine Parts of Date using the DATE Function in Excel
3. How to Use the YEAR function to extract the year part of a date
4. How to Use the DATEDIF function to calculate the ages of employees
5. Use the DAYS360 function to calculate with a 360-day year