How to Use Excel WORKDAY.INTL Function (with Video)

Excel WORKDAY.INTL Function (Example + Video)


When to use Excel WORKDAY.INTL Function

Excel WORKDAY.INTL function can be used when you want to get the date after a given number of working days. For example, if I start a project today and it will take 20 working days to complete, then I can use WORKDAY function to get the completion date. This function is best used when you want to calculate the invoice due date, project due date, delivery date, etc.

This function differs from Excel WORKDAY function, as here you can specify the weekend to be days other than Saturday and Sunday.

What it Returns

It returns the serial number of the date that is after or before the specified number of working days (from the specified start date)


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

Input Arguments

  • start_date – a date value that represents the start date.
  • days – the total number of working days. These exclude the weekend. You can use a positive or a negative value here. A positive value calculates the date which is after the start date, and negative value calculates the date before the start date.
  • [weekend] – (Optional) It specifies the day of the weeks that are considered as the weekend. It is a number that maps to various combinations of weekends.
  • [holidays] – (Optional) It is a range of dates that are excluded from the calculations. For example, these could be national/public holidays. It could be a reference to the range of cells that contains the dates, or could be an array of serial numbers that represent the dates.

Additional Notes

  • A Date can be entered as:
    • A result from some other function
    • A date stored as text
    • A date entered as text (In double quotes)
  • A Weekend could be any two consecutive days or any single day of the week.
  • In case of part-time jobs or non-consecutive non-working days, type the below format in [weekend] section.
    • Suppose you only work on Monday and Wednesday, use “0101111” [0 represents a working day and 1 represents non-working day].
      • The first number in this format represents Monday and the last represents Sunday.
      • Use this number in double quotes.
      • With the same logic, “1010111” indicates that only Tuesday and Thursday are working, and rest 5 days are non-working.

Excel WORKDAY.INTL Function – Live Example

Excel WORKDAY.INTL Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Tutorials: