This formula subtracts 15 days from the date in cell C1.Ĭells A1 and C1 show the due dates (2/8/12 and 3/9/12) for the February and March account balances. In cell D1, type =C1-15, and then press RETURN. This formula adds 30 days to the date in cell A1.
In cell C1, type =A1+30, and then press RETURN. This formula subtracts 15 days from the date in cell A1. 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. Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 More.
