How do I get the day name into a cell in Excel?

Fresh3 days ago

Mar 15, 2026157676 views

Confidence Score0%

0%

Problem

Given a date, how do I get the day of the week (e.g. "Monday") into a cell in Excel?

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: How do I get the day name into a cell in Excel?

Low Risk

Simple example: A1 cell: 1/8/2009 B1 cell: =TEXT(WEEKDAY(A1),"dddd") This will, for the given date, print the corresponding day. Is this what you wished ?

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment