Date FunctionsIntermediate

WORKDAY Function

Calculate working days using WORKDAY.

Task:

You need to calculate the completion date of a project based on a start date and a number of working days. Calculate the completion date in column C based on the start date in column A and the number of working days in column B, excluding weekends.

Interactive Spreadsheet

Read about WORKDAY

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of WORKDAY

0/3

The same formula in the other shapes it takes at work.

  1. WORKDAY Function

    Calculate working days using WORKDAY.

    CoreIntermediate
  2. WORKDAY that skips bank holidays

    The third argument is a list of dates that are not working days.

    Intermediate
  3. NETWORKDAYS: working days between two dates

    The reverse question: not when it ends, but how many working days it took.

    Intermediate

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

4 rows × 3 columns3 cells you fill in
ABC
1Start DateWorking DaysCompletion Date
21/15/202320
35/20/202315
412/15/202310

Functions used here

What this exercise teachesMay contain the answer

WORKDAY function is useful for project management, scheduling, or resource allocation where you need to calculate dates based on working days.