# How to Add or Subtract Days to a date in Google Sheets ( Quick & Easy Guide )

In this tutorial, you will learn How to Add or Subtract Days to a date in Google Sheets.

## How to Add or Subtract Days to a date in Google Sheets

Enclosed are the steps to Add or Subtract days to a date in Google Sheets.

You can use the below formula to add or subtract days to a date in Google Sheets

#Add 5 days to a date

=A2+5 ( A2 is the cell reference in Google Sheet)

#subtract 5 days to a date

=A2-5 ( A2 is the cell reference in Google Sheet)

To add or subtract workdays in Google Sheets use the below formula :

=workday(A2, 5)

#Subtract 5 workdays to a date in Google Sheet

=workday(A2, -5)

Assuming we have the following date list in Google Sheets.

Click on the Cell B2 to Select it and type the formula in the function area “=A2+5″ without quotes then press enter as shown below .

Confirm Auto-fill to apply the formula down the cells

• 5 days will be added to each date .

Now we will subtract 5 days to each date :

Click on the Cell B2 to Select it and type the formula in the function area “=A2-5without quotes then press enter as shown below .

5 days will be subtracted to a date and will be displayed in the Selected Column.

You might come across a situation where you need to add or subtract workdays to a date in Google Sheets.In such cases the workday() function can come to our rescue.

Workday function will calculate the end date after the provided number of working days.

### Syntax

`WORKDAY(start_date, num_days, [holidays])`

Here is the formula to add 5 Workdays to a date in Google Sheet:

`WORKDAY(A2,5)`

Here A2 is the cell reference for start date.

We will add 5 workdays to a date using the above formula:

• Click on the Cell B2 to Select it and type the formula in the function area “=WORKDAY(A2,5)” without quotes then press enter as shown below .

5 workdays will be added as per the formula.

Similary you can subtract 5 Workdays to a date with a small change in the formula in Google Sheet.

• Click on the Cell B2 to Select it and type the formula in the function area “=WORKDAY(A2,-5)” without quotes then press enter as shown below .

## How to Add or Subtract Days to a date in Google Sheets

We hope this tutorial on How to Add or Subtract Days to a date in Google Sheets was helpful.

Related articles :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )