Table of Contents
Adding and subtracting days in Google Sheets allows you to easily perform date calculations and keep track of important dates. To do so, you can utilize the DATE function which takes in three arguments – year, month, and day. By adding or subtracting a specified number of days to the date, you can get the desired result. For example, to add 10 days to a date, the formula would be =DATE(year, month, day + 10). Similarly, to subtract 5 days, the formula would be =DATE(year, month, day – 5). This feature in Google Sheets is particularly useful for planning and organizing tasks, events, and deadlines.
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.
Example 1: Add & Subtract Days in Google Sheets
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:
Example 2: Add & Subtract Workdays in Google Sheets
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:
Cite this article
stats writer (2024). How can I add and subtract days in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-days-in-google-sheets-can-you-provide-some-examples/
stats writer. "How can I add and subtract days in Google Sheets?." PSYCHOLOGICAL SCALES, 16 May. 2024, https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-days-in-google-sheets-can-you-provide-some-examples/.
stats writer. "How can I add and subtract days in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-days-in-google-sheets-can-you-provide-some-examples/.
stats writer (2024) 'How can I add and subtract days in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-add-and-subtract-days-in-google-sheets-can-you-provide-some-examples/.
[1] stats writer, "How can I add and subtract days in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, May, 2024.
stats writer. How can I add and subtract days in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.