Use the WORKDAY and WORKDAY.INTL functions to calculate workdays with custom weekends

Use the WORKDAY and WORKDAY.INTL functions to calculate workdays with custom weekends

Use the WORKDAY and WORKDAY.INTL functions to calculate workdays with custom weekends

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

Step 1: Define the start_date, number of workdays to add, and optionally a list of holidays.

Step 2: For WORKDAY.INTL, also define the custom weekend pattern.

Step 3: Enter the appropriate formula in a cell and press Enter.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com