WORKDAY.INTL Function in Excel: Syntax, Examples and Free Practice
WORKDAY.INTL is an Excel Date & Time function. Returns a future/past workday with a custom weekend.
WORKDAY.INTL syntax
Arguments
start_date: The date to start counting fromdays: How many days to shift byweekend: Which days count as the weekend (optional)holidays: A list of dates to exclude as holidays (optional)
When to use WORKDAY.INTL
WORKDAY.INTL is used in scheduling, deadline tracking, and reporting that spans specific date ranges.
Practice WORKDAY.INTL online, free
Open the live Excel-style spreadsheet and try WORKDAY.INTL yourself. No Excel install or sign-up needed to start.
Practice WORKDAY.INTL now →More Date & Time functions
Frequently asked questions
What does the WORKDAY.INTL function do in Excel?
Returns a future/past workday with a custom weekend.
What is the syntax of WORKDAY.INTL in Excel?
The syntax is =WORKDAY.INTL(start_date, days, [weekend], [holidays]). start_date: The date to start counting from; days: How many days to shift by; weekend: Which days count as the weekend (optional); holidays: A list of dates to exclude as holidays (optional).
Where can I practice WORKDAY.INTL online for free?
Open the free live spreadsheet on Cellgrids and try WORKDAY.INTL yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Date and Time functions · Excel case studies · Excel tutorials · Excel shortcuts