Home / MS-Excel / Functions and Formula

Return the Weekday of a Date

When finding the weekday associated with any date, most of us would rather see it returned as a name of the day, rather than as a number (the default).

This tutorial shows how to extract the weekday of any date by using the WEEKDAY function. By default, the day is given as a whole number, ranging from 1 (Sunday) to 7 (Saturday). However, this is often meaningless, and we usually would rather see the weekday returned as a name, such as Monday/Mon, Tuesday/Tue, and so on.

In this tutorial:

  1. Get the Weekday as a Number
  2. Return the Weekday as Weekday Name
  3. Return the Weekday as Weekday Text