# 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.

Enter your due dates in column A.

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.

In cell C2, type

**= A2 + B2**and 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 value 4/15/19 back.**

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

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).

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 under**Category**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.

In cell A1, type

**02/08/13 a.**In cell B1, type

**= A1-15**a.In cell C1, type

**= A1 + 30**a.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:

In cell A1, type

**October 24th, 2013.**In cell B1, type

**= EDATE (A1; 16) a.**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 |
---|---|---|---|

| 3 (Add 3 Years) | = DATE (YEAR (A2) + B2, MONTH (A2), DAY (A2)) | 10/24/2016 |

| -5 (subtract 5 years) | = DATE (YEAR (A4) + B4, MONTH (A4), DAY (A4)) | 10/24/2008 |

- Book titles are capitalized
- Is concrete alkaline or acidic
- What are the best films for entrepreneurs
- What is Jenny McCarthy's IQ
- What are Anupam Kher's best films
- What werewolf bit Remus Lupine
- Land with the best mobile game developers
- What are some examples of social facts
- Which superhero films are overrated
- Why do kidney failure cause tetany
- Which is your favorite book series
- Is lemon good for weight loss
- When can I buy Baby Yoda
- Why are grains tax-free
- Who was your banking partner at school
- How important were Shisui Uchiha's eyes
- What is the structure of innovation management
- Why can't I get a job
- What is custom software development
- Have coding elements a placement cell
- What are the causative agents of soil formation
- Why are 99 people risk averse
- How does the project management work
- Klitzman is a Jewish family name