Add or Subtract Dates Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007 Suppose you want to adjust a project's schedule date by adding two weeks to see what the new completion date will be, or you want to determine how long a single activity will take to complete in a list of project tasks. You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel. Add Days To Or Subtract Days From a Date Suppose that an account balance of yours is due on February 8, 2010. You want to transfer funds to your checking account so that those funds arrive 15 calendar days before that date. In addition, you know that your account has a 30 day billing cycle, and you want to determine when you should transfer funds for your March 2010 bill so that those funds are available 15 days before that date. In cell A1, type 2/8/10. In cell B1, type =A1-15. In cell C1, type =A1+30. In cell D1, type =C1-15. Cells A1 and C1 show the due dates (2/08/10 and 3/10/10) for the February and March account balances, and cells B1 and D1 show the dates (1/24/10 and 2/23/10) by which you should transfer your funds for those due dates. Add Months To Or Subtract Months From A Date You can use the to quickly add or subtract a specific number of whole months to or from a date. The EDATE function requires two values (also referred to as arguments): the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument (for example, =EDATE("2/15/10",-5). This formula results in the date 9/15/09. You can specify the value of the start date either by referring to a cell that contains a date value or by entering a date enclosed in quotation marks, such as "2/15/10". For example, suppose you want to add 16 months to October 16, 2009. In cell A5, type 10/16/09. In cell B5, type =EDATE(A5,16).
Add or Subtract Dates Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007 Suppose you want to adjust a project's schedule date by adding two weeks to see what the new completion date will be, or you want to determine how long a single activity will take to complete in a list of project tasks. You can add or subtract a number of days to or from a date by using a simple formula, or you can use worksheet functions that are designed to work specifically with dates in Excel. Add Days To Or Subtract Days From a Date Suppose that an account balance of yours is due on February 8, 2010. You want to transfer funds to your checking account so that those funds arrive 15 calendar days before that date. In addition, you know that your account has a 30 day billing cycle, and you want to determine when you should transfer funds for your March 2010 bill so that those funds are available 15 days before that date. In cell A1, type 2/8/10. In cell B1, type =A1-15. In cell C1, type =A1+30. In cell D1, type =C1-15. Cells A1 and C1 show the due dates (2/08/10 and 3/10/10) for the February and March account balances, and cells B1 and D1 show the dates (1/24/10 and 2/23/10) by which you should transfer your funds for those due dates. Add Months To Or Subtract Months From A Date You can use the to quickly add or subtract a specific number of whole months to or from a date. The EDATE function requires two values (also referred to as arguments): the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument (for example, =EDATE("2/15/10",-5). This formula results in the date 9/15/09. You can specify the value of the start date either by referring to a cell that contains a date value or by entering a date enclosed in quotation marks, such as "2/15/10". For example, suppose you want to add 16 months to October 16, 2009. In cell A5, type 10/16/09. In cell B5, type =EDATE(A5,16).
Excel_Add_Subtract_Dates.13593902.docx