In cell B1, type =A1-15, and then press RETURN. 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 2012 bill so that those funds are available 15 days before that date. You want to transfer funds to your checking account so that those funds arrive 15 calendar days before the due date. Suppose that an account balance is due on February 8, 2012. You can add or subtract a number of days, months, or years to or from a date by using a simple formula, or you can use sheet function that are designed to work specifically with dates. Suppose you want to adjust a project’s completion date by adding two weeks or you want to determine the length of an individual task in a list of tasks.
