Add Workdays in Google Sheets

To add or subtract workdays days from a date, respecting holidays but assuming a 7-day week: you can use the WORKDAY.INTL function with an argument that tells it how many days should be subtracted/added as well as which specific holidays to ignore. In our formula below C2 for this example:


Add workdays no weekends in google sheets1

With this formula, you can have a Thursday evening deadline instead of Monday afternoon! This means that all days in the week are treated as working hours. With two holidays  in range A7:A8  and weekends set using the special syntax “0000000“, your work will be done by 5/29/2022, at midnight PST.


WORKDAY.INTL allows you to calculate a date in the future or past that respected holidays and weekends with its special codes for designating which days are considered as such, but using masks is more flexible since it allows any day of the week to be designated into being treated like weekend ones & zeros!

You can calculate the number of days required to complete your project in an official workplace with this handy formula. Simply multiply Saturday’s total hours by 0,8 and add it onto Sunday-Friday count!

To add days excluding weekends, simply do the following:

Type this formula =WORKDAY(A2, B2) into the blank cell, and press Enter key to get your answer.

Add workdays no weekends in google sheets1

Tip: To change the start date of your spreadsheet, simply enter “A2” as desired. This will allow you to input future dates into B2 for each day added on top!

We have now reached the end date, which adds 50 business days, excluding weekends.

Note: The number you’re trying to math is a 5-digit one, so in order for it to show up on your screen correctly formatted as date, click Format> Number > Date. See screenshot:

Add workdays no weekends in google sheets1

Now that you have cells containing all of your holiday data, excluding weekends and any other days we want is easy.

Type this formula =WORKDAY(A2, B2, A7:A8) in blank cells and hit the enter to see the result.

Add workdays no weekends in google sheets1

Tip: To create a formula that excludes holidays, use this equation. A2 is the start date, and A7:A8 are days you want to be excluded from your calculation.

Related Functions

  • Google Sheets WORKDAY function
    The Google Sheets WORKDAY function returns a serial number that represents a date that is the indicated number of working days before or after the starting date you specified.The syntax of the WORKDAY function is as below:=WORKDAY(start_date, days, [holidays])…
  • Google Sheets WORKDAY.INTL function
    The Google Sheets WORKDAY.INTL function returns the serial number of the date before or after a specified number of workdays.The syntax of the WORKDAY.INTL function is as below:= WORKDAY.INTL (start_date, days, [weekend], [holidays])…


Google Sheets WORKDAY.INTL Function

This post will guide you how to use Google Sheets WORKDAY.INTL function with syntax and examples.


The Google Sheets WORKDAY.INTL function returns the serial number of the date before or after a specified number of workdays. And this function allows you to exclude weekends and holidays as non-working days. You can use the WORKDAY.INTL function to calculate working days excluding weekdays and holidays.

The WORKDAY.INTL function can be used to calculate the date after a specified number of workdays excluding specified weekend days and in google sheets. The purpose of this function is to get date n working days in future or past.

The WORKDAY.INTL function is a build-in function in Google Sheets and it is categorized as a Date function.


The syntax of the WORKDAY.INTL function is as below:

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

Where the WORKDAY.INTL function arguments is:

  • Start_dateThis is a required argument. The starting date from which you want to count the number of working days. The date should be typed as a valid Excel time a serial date.
  • days – This is a required argument. The number of working days that you want to add. A positive value for days yields a future date; a negative value yields a past date.
  • Weekend This is an optional argument. Determine which days of the week that are weekend days and are not considered working days. Weekend is a weekend number and it can be one of the following numbers.
weekend-number Weekend days
1 or omitted Saturday, Sunday
2 Sunday, Monday
3 Monday, Tuesday
4 Tuesday, Wednesday
5 Wednesday, Thursday
6 Thursday, Friday
7 Friday, Saturday
11 Sunday only
12 Monday only
13 Tuesday only
14 Wednesday only
15 Thursday only
16 Friday only
17 Saturday only
  • holidays – This is an optional argument. The list of holidays that you want to exclude from the working days. It can be a range of cells that contain the holiday dates or it can be a list of serial numbers that represent the holiday dates.


  • If any argument is not a valid date, a #VALUE! Error is returned.
  • If start date value plus days is an invalid date, the WORKDAY function returns #NUM! Error.
  • A serial date is how the google sheets stores dates and it represents the number of days since 1900-01-01, so the January 1, 1900 date is serial number 1 by default.
  • If days value is not an integer number, it will be truncated.
  • If a weekend string is of invalid length or contains invalid characters, WORKDAY.INTL returns the #VALUE! Error value.

Google Sheets WORKDAY.INTL Function Examples

The below examples will show you how to use google sheets WORKDAY.INTL Function to return the working days from the start date.

1# get the date 50 WORKDAY.INTLs from the starting date “3/20/2021”, enter the following formula in Cell B1.


google sheets workday.intl function1