Administration and Executive AssistantTier 725 minadvanced

NETWORKDAYS.INTL Weekend Patterns

Count working days for a branch whose weekend falls on different days than the default.

What you will learn

• Use NETWORKDAYS.INTL's weekend argument to define a custom weekend pattern
• Explain that leaving the weekend argument out silently assumes a Saturday/Sunday weekend
• Recognise when a business's actual weekend does not match that default

Excel skills

NETWORKDAYS.INTL · Date Calculations

The task

This branch's week runs Sunday to Thursday - Friday and Saturday are the weekend. Work out the number of working days between each order and delivery date, in column C.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free