MS-Excel / Functions and Formula

Return the Weekday as Weekday Text

If you won't be using the weekday that is returned in any further calculations, you can use either of the formulas that follow( TEXT or WEEKDAY with CHOOSE) to return the weekday of a date as text.

The first formula uses TEXT and assumes you have a valid date, such as 31-Jul-2007, in cell A1:

=TEXT(A1,"DDDD")

Given 31-Jul-2007 in cell A1 it will return Tuesday. Or you could hardcode the date like this:

=TEXT("31 Jul 2007","DDDD")

Alternatively, you could use a combination of the WEEKDAY and CHOOSE functions to get the same result:

=CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday", "Friday","Saturday")
[Previous] [Contents]

In this tutorial:

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