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 :
#Add 5 workdays to a date in Google Sheet
=workday(A2, 5)
#Subtract 5 workdays to a date in Google Sheet
=workday(A2, -5)
#Add or Subtract Days to a date in Google Sheets
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-5” without quotes then press enter as shown below .
5 days will be subtracted to a date and will be displayed in the Selected Column.
#Add & Subtract Workdays in Google Sheets
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