In this tutorial, you will learn how to add days to a date in Google Sheets.
How to Add Days to Date in Google Sheets
When working with dates in Google Sheets, you may find yourself needing to add days to a given date.
For example, you may want to schedule a meeting 10 days after the current date or two weeks after Christmas.
In this guide, we will explain how to add days to a given date in Google Sheets. We will also show you how to specifically account for just working days when making the calculation.
How to Find X Days After a Date in Google Sheets
Here’s how to find the date that is a certain number of days after a given date in Google Sheets.
First, select a new cell where we will perform our calculation.
In this example, we want to know the date that falls 100 days after January 1st, 2022.
We can simply add our desired number of days to our date value to retrieve the new date.
For example, we can add the number 100 to the date value January 1 2022 to return April 11 2022.
This operation works as intended because Google Sheets stores date values as serial numbers. This allows us to work around with dates as if they were numbers as well.
What if you need to add a specific number of workdays after a date? We can use the WORKDAY function instead.
The first argument of the workday function should be the date you want to add workdays to. The second function indicates the number of workdays after the specified date.
In the example below, we were able to determine the 15th workday after January 1st, 2022.
The WORKDAY function also includes an optional third argument where users can list holidays to skip over when performing the calculation.
This guide should be everything you need to add days to a date in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.