Date FunctionsIntermediate

WEEKDAY Function

Determine the day of the week using the WEEKDAY function.

Task:

You need to determine the day of the week for a list of dates. Determine the day of the week in column B for the dates in column A using the WEEKDAY function, displaying the result as a number (1-7).

Interactive Spreadsheet

Read about WEEKDAY

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 WEEKDAY

0/3

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

  1. WEEKDAY Function

    Determine the day of the week using the WEEKDAY function.

    CoreIntermediate
  2. WEEKDAY with Monday as day 1

    The second argument decides where the week starts — and makes weekends easy to test.

    Intermediate
  3. WEEKDAY to find the next Monday

    Subtract how far into the week you are, then jump a week ahead.

    Advanced

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 × 2 columns3 cells you fill in
AB
1DateWeekday
21/15/2023
35/20/2023
412/31/2023

Functions used here

What this exercise teachesMay contain the answer

WEEKDAY function is useful for determining the day of the week for scheduling, analysis, or reporting purposes.