Get the Weekday Name From A Date in Excel!
Tags: exceltutorials, gettheweekdayfromada, excel
Published: 2021-11-15 04:14:16

---
title: Get the Weekday Name From A Date in Excel!
published: true
date: 2021-11-11 00:21:00 UTC
tags: ExcelTutorials,GettheWeekdayfromaDa,Excel
canonical_url: https://geekexcel.com/get-the-weekday-name-from-a-date-in-excel-365-with-examples/
---

## Get the Weekday Name From a Date in Excel:

Sometimes we want to know the Weekday Name just because we forget that. So there are ways to Get the Weekday Name from a Date in Excel. Let’s step into this article and see how to ** Get the Weekday Name from a Date in Excel 365**.

## How to Format a Date as the Weekday Name?

- First, you are going to see how to format the date cells.
- Excel considers the date as serial numbers that start from 1 for the date 1900-01-01. You can format the date like yyyy-mm-dd, dd/mm/yyyy, dd-mm-yy, etc.
- Formatting options to these serial numbers display the Weekday name with custom format (dddd or dd).
- To do this,  **select**  the  **dates**  which you want to change into weekday names.
- On the  **Home**  tab,  **click**  the  **launch**   **icon**  at the corner of the  **numbers**  section. It will open the ** format cells**  dialog box.
- In the Format Cells dialog box, On the  **Number**  tab, select  **Custom**  as Category.
- Enter  **dddd**  in the  **type**  field for the  **full weekday name**  or enter  **DDD**  for  **the abbreviated**   **weekday**   **name**.
- Hit the  **Ok**  button.

![](https://geekexcel.com/wp-content/uploads/2020/07/sun27.png)

- Now it will display the Weekday Name in the Selected Cells according to the date you entered.

![](https://geekexcel.com/wp-content/uploads/2020/07/sun28.png)

## How to Get the Weekday Name using TEXT Function?

- You can use the **TEXT**  **Function** to convert any date into text strings using the Weekday Name Format.
- “ **= TEXT ( Value, Format )** ” it is the syntax for TEXT Function.
- For example, you need to enter this formula in the Formula bar like ” =TEXT ( B2, “dddd” ).
- It will convert the Date into Weekday Name.

![](https://geekexcel.com/wp-content/uploads/2020/07/sun29.png)

## How to Get the Weekday Number using WEEKDAY Function?

- You can also use the **WEEKDAY**  **Function** to get the Weekday Number.
- ” **=WEEKDAY ( Date, [Type] )** ” is the syntax for WEEKDAY Function.
- **Date** – the date to find the weekday number.
- **Type** – the weekday number type to return.

![](https://geekexcel.com/wp-content/uploads/2020/07/sun30.png)

- For example, here we enter this formula as “** =WEEKDAY( B2, 1 )** ” this formula will calculate the date value into the corresponding weekday value.
- The second argument will return 1 for Sunday through to 7 for Saturday, and it returns  **6**. So the Weekday for this date value is  **Friday**.

![](https://geekexcel.com/wp-content/uploads/2020/07/sun31.png)

### Combining Switch with WEEKDAY to return the Weekday Name:

- The WEEKDAY function only returns the number corresponding to that weekday name.
- You can  **Combine Switch Function to get the WEEKDAY Name**.
- Use the following syntax of Switch Function to assign a Weekday Name to each number in the formula.
- **” = SWITCH ( WEEKDAY (b2, 1), 1,”Sun”, 2, “Mon”, 3, “Tue”, 4, “Wed”, 5, “Thurs”, 6, “Fri”, 7, “Sat” ) “**

![](https://geekexcel.com/wp-content/uploads/2020/07/sun32.png)

## How to Get the Weekday Name using Power Query?

-  As we know, Power Query is used for data transformation, so We might use it for converting the date value into Weekday Name.
- **Select the cells**  that contain the date inside it.
- On the  **data**  tab, Select From  **Table/Range ** option. It will open the  **Power Query Editor**  Dialog box.
- In Power Query Editor, select the  **Date**   **Column. ** Then go to the  **Add**   **Column**  tab, Select  **Date**  Option, it will display the menu.
- Choose  **Day**  from the menu and select the  **Name of the Day**  option.
- It will display the WEEKDAY NAMES for the corresponding date you given in the date column.

![](https://geekexcel.com/wp-content/uploads/2020/07/sun33.png)

- You can see the following code that is generated automatically in the formula bar.
- ” **= Table.AddColumn(#”Changed Type”, “Day Name”, each Date.DayOfWeekName([Column1]), type text)** “.
- It uses the  **Date.DayOfWeekName**   **Function**  to find the weekdays.

## Wind-Up:

In this post, you can quickly learn the steps to ** Get the Weekday Name from a Date**   **in Excel**  365. Kindly, Leave your  **feedback/queries**  in the below comment section. Thanks for visiting [**Geek Excel.**](https://geekexcel.com/) Keep Learning!!