What is 60 days from today

Add or subtract date values

Suppose you want to adjust a project's schedule by adding two weeks to see what the new completion date will be, or you want to see how long a single activity in a list of project tasks will take. You can add or subtract a number of days to or from a date using a simple formula, or you can use worksheet functions designed specifically for working with dates in Excel.

Adding or subtracting days from a date

Let's say an invoice from you is due on the second Friday of every month. You want funds in your verification account via wire transfers so that these funds arrive 15 calendar days before that date, so you subtract 15 days from the due date. The following example shows you how to add and subtract dates by entering positive or negative numbers.

  1. Enter your due dates in column A.

  2. Enter the number of days to add or subtract in column B. You can enter a negative number to subtract days from the start date and a positive number to add to their date.

  3. In cell C2, type = A2 + B2and copy down as needed.

Adding or subtracting months from a date with the EEDATE function

You can use the EDATE function to quickly add or subtract months from a date.

The EDATE function required two arguments: the start date and the number of months you want to add or subtract. To subtract months, enter a negative number as the second argument. For example = EDATE ("9/15/19"; - 5) the value4/15/19 back.

  1. In this example, you can enter your start dates in column A.

  2. Enter the number of months to add or subtract in column B. To indicate whether to subtract a month, you can add a minus sign (-) in front of the number (for example, -1).

  3. Give You = EDATE (A2; B2) in cell C2 and copy down as needed.

    Hints:

    • Depending on the format of the cells that contain the formulas you entered, Excel may display the results as serial numbers. For example, February 8, 2019 might appear as 43504.

    • Excel stores dates as serial numbers so that they can be used in calculations. By default, 01/01/1900 is the sequential number 1 and 01/01/2010 is the sequential number 40179, as this day follows 01/01/1900 after 40,178 days.

    • When your results are shown as serial numbers, highlight the cells in question and continue with the following steps:

      • To press You CTRL + 1, to the dialog box Format cells to start and click the tab Number.

      • click You underCategory Date,select the date format you selected, then click OK. The value in the respective cells is displayed as a date instead of a serial number.

Adding or subtracting years from a date

In this example, we're adding and subtracting years from a starting date using the following formula:

= DATE (YEAR (A2) + B2, MONTH (A2), DAY (A2))

How the formula works:

  • The function YEAR finds the date in cell A2 and returns 2019. Then add three years from cell B2, resulting in 2022.

  • The Functions MONTH and DAY only return the original values ​​from cell A2, but the DATE function requires them.

  • Finally, the function combines DATE these three values ​​on a date that is 3 years in the future - 08.02.22.

Add or subtract a combination of days, months, and years to / from a date

In this example, we're adding and subtracting years, months, and days from a starting date using the following formula:

= DATE (YEAR (A2) + B2; MONTH (A2) + C2; DAY (A2) + D2)

How the formula works:

  • The function YEAR finds the date in cell A2 and returns 2019. Then a year from cell B2 is added, resulting in 2020.

  • The function MONTH returns 6, then adds 7 to it from cell C2. This becomes interesting because 6 + 7 = 13, i.e. H. 1 year and 1 month, is. In this case, the formula will recognize this and automatically add another year to the result and it will bump into 2021 from 2020.

  • The DAY function returns 8 and adds 15 to it. This works similarly to the MONTH part of the formula if you omit the number of days in a given month.

  • The DATE function then combines these three values ​​into a date that is 1 year, 7 months, and 15 days in the future - 23.01.21.

Here are a few ways you can use formula or worksheet functions that work with dates, such as: For example, if you add two weeks or the time it takes to complete a task, find the impact on the project plan.

For example, let's say your account has a 30-day billing cycle and you want the balance in your account 15 days prior to the March 2013 billing date. Here's how you would use a formula or function to work with dates to do this.

  1. In cell A1, type 02/08/13 a.

  2. In cell B1, type = A1-15 a.

  3. In cell C1, type = A1 + 30 a.

  4. In cell D1 = C1-15 a.

Add months to a date

We use that Function EDATE, and you need the start date and the number of months you want to add. To add 16 months to 10/24/13:

  1. In cell A1, type October 24th, 2013.

  2. In cell B1, type = EDATE (A1; 16) a.

  3. To format the results as dates, select cell B1. Click the arrow next to Number format, > Short date.

Subtract months from a date value

We use the same EDATE function to subtract months from a date.

Enter a date in cell A1 and the formula in cell B1 = EDATE (04/15/2013; -5) a.

Here we indicate the value of the start date, which includes a date enclosed in quotation marks.

You can also just refer to a cell that contains a date value or by using the formula = EDATE (A1; -5)use for the same result.

Further examples

How to add or subtract years from a date

Start date

Years added or subtracted

formula

Result

10/24/2013

3 (Add 3 Years)

= DATE (YEAR (A2) + B2, MONTH (A2), DAY (A2))

10/24/2016

10/24/2013

-5 (subtract 5 years)

= DATE (YEAR (A4) + B4, MONTH (A4), DAY (A4))

10/24/2008