Administration and Executive AssistantTier 250 minintermediate

Date Maths with South African Holidays

Calculate working days and exclude public holidays.

What you will learn

• Use NETWORKDAYS for business days
• Use NETWORKDAYS.INTL for working days with custom weekends
• Build a holiday calendar in Excel
• Calculate turnaround times excluding weekends and holidays

Excel skills

NETWORKDAYS, NETWORKDAYS.INTL, date arithmetic · Business Day Calculation

The task

Twenty-five orders, with the date placed and the date delivered. I need working days to deliver for each one, and it has to exclude South African public holidays, not just weekends. We have had a run of complaints about SLA reporting looking better than it actually is, and it turned out the old sheet was counting Heritage Day and Youth Day as working days.

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