In this article:

Find the Date X Days After The Start Date in Google Sheets

Addition is enough (also subtraction)

As we have said in our previous tutorial on finding the difference between two dates, Google Sheets stores the dates in a special format which allows one to perform addition and subtraction. 

To find a certain date after the start date, simply add the number of days through simple addition. Note that the count begins the next day after the specified start date. 

Similarly, if you’d like to find the date a certain number of days before the given date, you can simply do so through subtraction. Subtraction also skips the given date in the calculations. 

Shown below are examples:

The addition operation works in finding the date in the future or the past.
The addition operation works in finding the date in the future or the past. 

The EDATE function

If you need to look for a certain date a given number of months after the given date, you can use the EDATE function. The EDATE function gives you the date a certain number of months after or before the given date. The syntax of the function is as follows:

=EDATE(start_date, months)

Both the start_date and months can either include the actual dates or point to the cell containing the given values. The output is given in an MM/DD/YYYY format.

You can check the examples below:

EDATE function applied to a variety of dates and number of months, both forward and backward.
EDATE function applied to a variety of dates and number of months, both forward and backward.

The WORKDAY and WORKDAY.INTL functions

Google Sheets also allows you to instead count just the workdays, not including the weekend and the holidays. You can use the WORKDAY and WORKDAY.INTL functions for this. 

The WORKDAY function automatically ignores the weekends (Saturday and Sunday) when counting the dates. The syntax is given as follows:

=WORKDAY(start_date, num_days, [holidays])

The WORKDAY function allows you to specify the start date, the number of days, and also the holidays that fall on the workdays covered by the number of days. You can specify the cells containing the start date, the number of days, and the holidays. The examples are shown below:

WORKDAY function applied to various start dates. The addition method is also included for comparison, showing that the WORKDAY function excludes the weekends in the calculation.
WORKDAY function applied to various start dates. The addition method is also included for comparison, showing that the WORKDAY function excludes the weekends in the calculation. 

The WORKDAY.INTL function gives you more versatility by allowing you to specify the days that comprise the weekend. The syntax of the function is given below:

=WORKDAY.INTL(start_date, num_days, [weekend], [holidays])

The weekends can be specified using two different methods: the string method and the number method. By default, the weekend is set to 1, specifying Saturday and Sunday as the weekend days. The string method is a simpler method since it visualizes the days of the week into a string of 0’s and 1’s. Here’s a few examples:

0000011 - weekend at Saturday and Sunday

1000000 - weekend at Monday

1010100 - day-offs at Monday, Wednesday, and Friday

Make sure the weekend format is enclosed in quotation marks. You can check the examples below:

WORKDAY.INTL function applied to a single start date but with a variety of different days set as weekends, yielding different end dates.
WORKDAY.INTL function applied to a single start date but with a variety of different days set as weekends, yielding different end dates. 

Sample sheet

You can check the sample sheet below to see these samples work in Google Sheets:

Days After Given Date Sample Sheet

Schedule a free automation consult
Learn more

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started