# How to Add & Subtract Days in Google Sheets (With Examples)

We can use the following simple formulas to add or subtract days to a date in Google Sheets:

#add 10 days to the date in cell A2
=A2+10

#subtract 10 days from the date in cell A2
=A2-10

And we can use the following formulas to add or subtract workdays (Monday through Friday) to a date:

#add 10 workdays to the date in cell A2
=workday(A2, 10)

#subtract 10 workdays from the date in cell A2
=workday(A2, -10)

The following examples show how to use each of these formulas in practice.

Suppose we have the following list of dates in Google Sheets:

We can use the following formula to add 10 days to each date:

And we can use the following formula to subtract 10 days from each date:

In some scenarios, we may only want to add or subtract workdays to dates in Google Sheets. Fortunately we can use the workday() function to do so.

The following formula shows how to add 10 workdays to each date:

And the following formula shows how to subtract 10 workdays from each date:

The following tutorials explain how to perform other common operations in Google Sheets:

May 13, 2024
April 25, 2024
April 19, 2024
April 18, 2024

## 2 Replies to “How to Add & Subtract Days in Google Sheets (With Examples)”

1. Eva Kettler says:

Hi – is there a way to make a cell color change when today’s date is 10 days prior to the date in the cell? My example: the column has expiration dates. I’d like the cell color to change to yellow when I’m 10 days before the expiration date; that way, that particular date stands out in the spreadsheet and I know to go check that date. Is that possible?
Thanks so much!