How-To-Get-The-Weekday-Name-From-A-Date How To Get The Weekday Name From A Date

Example

=TEXT(B3,”dddd”)

Generic Formula

=TEXT(Date,”dddd”)
Date – This is the date which you want to find what weekday it falls on.

What It Does

This formula will return the weekday for a given date.

How It Works

The TEXT function will return a text string based on any custom format. This formula uses the “dddd” custom date format to return the weekday name for any given date. In our example, TEXT(“2030-01-01″,”dddd”) will return “Tuesday” since January 1st 2030 falls on a Tuesday.

We can also use the “ddd” custom format to return abbreviated weekday name: Mon, Tue, Wed, Thu, Fri, Sat & Sun.