Skip to content

Day of the week from a date

Show the weekday name, like Monday, for any date.

The formula

Argument separator
Excel and Google Sheets
=TEXT(A2, "dddd")

How it works

  1. A2

    The date.

  2. "dddd"

    Full day name. Use "ddd" for short names like Mon, or "mmmm" for the month name.

Example

A: DateB: Result
2026-11-11Wednesday
2026-12-25Friday

Tips

  • The name follows your spreadsheet's language settings.