# How to Add & Subtract Days in Google Sheets

To add or subtract days in Google Sheets, you can use the DATE, DATEVALUE, and EDATE functions along with basic arithmetic operations. Here's a step-by-step guide on how to do this:

## Add Days

- Open your Google Sheets document.
- Click on the cell where you want the result to be displayed.
- Use the following formula to add days to a date:

`=DATE(YEAR(date), MONTH(date), DAY(date) + number_of_days)`

Replace `date`

with the cell reference containing the date, and `number_of_days`

with the number of days you want to add.

Example:

Let's say you have a date in cell A1 (e.g., 10/5/2021) and you want to add 7 days to it. You'll use the following formula:

`=DATE(YEAR(A1), MONTH(A1), DAY(A1) + 7)`

The result in the selected cell will be 10/12/2021.

## Subtract Days

- Open your Google Sheets document.
- Click on the cell where you want the result to be displayed.
- Use the following formula to subtract days from a date:

`=DATE(YEAR(date), MONTH(date), DAY(date) - number_of_days)`

Replace `date`

with the cell reference containing the date, and `number_of_days`

with the number of days you want to subtract.

Example:

Let's say you have a date in cell A1 (e.g., 10/5/2021) and you want to subtract 7 days from it. You'll use the following formula:

`=DATE(YEAR(A1), MONTH(A1), DAY(A1) - 7)`

The result in the selected cell will be 9/28/2021.