Date Functions
Intermediate

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).

Learning Objectives:

  • Learn WEEKDAY function
  • Understand day of the week determination
  • Practice date-based analysis
Hints

Solve without hints for +5 XP

Interactive Spreadsheet

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.

AB
1DateWeekday
21/15/2023
35/20/2023
412/31/2023
What this exercise teaches (contains the answer)

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

Functions used here