How to / Dates

How to get the day of the week from a date in Excel

Use =TEXT(A2, "dddd") for the name of the day, such as Saturday. For a number from 1 to 7, use WEEKDAY.

The name of the day

ABC
1Date
22026-03-14Saturday
32026-03-16

In C2: =TEXT(A2, "dddd") → Saturday

How it works

  1. TEXT shows a date in the format you give it.
  2. "dddd" is the full name of the day. "ddd" is the short one.
  3. The result is text, for labels and headings. It cannot be used in date calculations.

Variations

  1. The short name

    ABC
    1Date
    22026-03-14Sat
    32026-03-16

    In C2: =TEXT(A2, "ddd") → Sat

  2. The day as a number, Monday = 1

    ABC
    1Date
    22026-03-146
    32026-03-16

    In C2: =WEEKDAY(A2, 2) → 6

    Without the 2, the week starts on Sunday and Saturday is 7.

  3. Weekend or weekday?

    ABC
    1Date
    22026-03-14Weekend
    32026-03-16

    In C2: =IF(WEEKDAY(A2, 2)>5, "Weekend", "Weekday") → Weekend

  4. The name of the month

    ABC
    1Date
    22026-03-14March
    32026-03-16

    In C2: =TEXT(A2, "mmmm") → March

  5. The date written out

    ABC
    1Date
    22026-03-1414 March 2026
    32026-03-16

    In C2: =TEXT(A2, "d mmmm yyyy") → 14 March 2026

Watch out for

Doesn't work on your data? Paste your formula into the formula checker with a few rows of your sheet. It points at the part that fails and says why.

Functions used

Practise it

Related