Skip to content

Get the Day Name from Date Values

Have you ever found yourself working with dates in Google Sheets or Excel and wanted to get back the day of the week from that date?

Of course, you could use the WEEKDAY function, but this is only going to give you back a number from one to seven. What if you want the name of the weekday instead?

This article will show you how to quickly and easily get back the name of the weekday based on a given date.

Get the Full Name

Let’s say you have the following list of dates.

Your goal is to get back the full name of each weekday for each date value.

To do this, enter the following formula into cell B2.

=TEXT(A2,"DDDD")

The text function will take the date value in cell A2 and give you back the full name of the weekday due to the formatting code supplied in the second argument.

With the formula written, all that’s left is to use the fill handle to drag the formula down for all the remaining dates.

Get the Shorthand Version of the Name

Here is the same list of dates from the previous example.

This time, your goal is to get back the shorthand version of the weekday for each date value.

To do this, enter the following formula into cell B2.

=TEXT(A2,"DDD")

The text function will take the date value in cell A2 and give you back the shorthand version of the weekday due to the formatting code supplied in the second argument.

With the formula written, all that’s left is to use the fill handle to drag the formula down for all the remaining dates.

By the way, this method works for both Microsoft Excel and Google Sheets! And that is how to quickly and easily get back the name of the weekday based on a given date.

See It In Action

Check out the video below to see this same method used in Google Sheets!

This Post Has 2 Comments

  1. I’ve found that the TEXT function is so helpful! Just one more capability to add to the books!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top