Start_date - the start date from which to count the number of months.In your EDATE(start_date, months) formulas, you supply the following 2 arguments: It is available in all versions of Excel 2007 and higher. Microsoft Excel provides a special function that returns a date that is a specified number of months before or after the start date - the EDATE function. Add or subtract months to a date with Excel EDATE Subtract months from date: =DATE(YEAR(A2), MONTH(A2) - 2, DAY(A2))Įxample 2.Add months to date: =DATE(YEAR(A2), MONTH(A2) + 2, DAY(A2)).The real formulas could look similar to these: =DATE(YEAR( date), MONTH( date) + N months, DAY( date)) =DATE(YEAR(A2), MONTH(A2) - $C$2, DAY(A2))Īnd of course, you can type the number of month to add or subtract in the formula instead of referring to a cell: Naturally, nothing prevents you from typing the minus sign directly in the formula to subtract months from a date: Yep, it's that simple :) If you type a negative number in C2, the formula will subtract months instead of adding them:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |