How To Get The Weekday Name From A Date

Example

=TEXT(B3,”dddd”)

Download Example File

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.

About the Author

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.