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

1. Open your Google Sheets document.
2. Click on the cell where you want the result to be displayed.
3. 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

1. Open your Google Sheets document.
2. Click on the cell where you want the result to be displayed.
3. 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.