Administration and Executive AssistantTier 720 minintermediate

WORKDAY vs Calendar Days

Set a deadline a given number of working days out, not calendar days.

What you will learn

• Use WORKDAY to add a number of working days to a start date
• Explain why simply adding the day count to the date counts weekends as if work happened on them
• Recognise that the difference grows with every weekend the span crosses

Excel skills

WORKDAY · Date Calculations

The task

Each task needs a set number of working days to complete. Work out the deadline for each one, in column C - the calendar date that many working days after the start.

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