Convert Date to Day of Week With Text Function in Excel Office 365!!
Tags: excelbasics, excelpreface, exceltutorials, convertdatetodayofwe
Published: 2021-01-18 04:03:55

---
title: Convert Date to Day of Week With Text Function in Excel Office 365!!
published: true
date: 2021-01-17 10:53:30 UTC
tags: ExcelBasics,ExcelPreface,ExcelTutorials,Convertdatetodayofwe
canonical_url: https://geekexcel.com/convert-date-to-day-of-week/
---

Sometimes you need to find the **[day of the week](https://geekexcel.com/how-to-use-excel-days-function-in-office-365-easy-steps/)** on a specified date. If you don’t know how to get it in Microsoft Excel, then we will assist you to learn the steps to achieve it. In this short article, we are going to see how to  **Convert Date to Day of the Week in Excel** using the **[TEXT Function](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)**. Let’s get into this article!!
## Description and Syntax of Text Function:

- The **[TEXT Function](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)** will accept a numeric value as the first argument, then convert it into the text based on the format code in the second argument.
- In Simple words, the text function converts a number to text in the given format.
- Using this function you can convert all the standard number formats such as date, times, currency to a text string in Excel.

The Syntax of the TEXT function is,

**=[TEXT](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)(value, format\_text)**

### Argument Explanation:

- **Value** – A number that you want to convert into text.
- **Format\_text** – The format that you want to apply to the given value.

## Practical Example:

Let’s see some examples for your reference.

### Example 1:

- Here, we are going to find the date to day of the week.
- To achieve this, we will use the Text function with this format code (“ddd” or “dddd”).
- If you want to get the day of the name as an abbreviation from dates such as Mon, Tue, etc. you can apply the below formula.

**=[TEXT](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)([date](https://geekexcel.com/enter-the-date-excel/), “ddd”)**

- Let’s see the below example image.
- You can see that the **formula**  is entered in [**cell**](https://geekexcel.com/excel-cells-options/)  **C2** and the  **input date**  is given in  **cell B2.**

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-7.png)<figcaption id="caption-attachment-20933">Enter the formula</figcaption>

- After applying the formula, click the **ENTER ** button.
- This formula will return the date to the day of the week as per the below example image.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Example-1-1.png)<figcaption id="caption-attachment-20934">Example 1</figcaption>

### Example 2:

- In case, you want to get the full day name of the week, such as Monday, Tuesday, etc.
- You need to enter the below formula.

**=[TEXT](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)([date](https://geekexcel.com/enter-the-date-excel/), “dddd”)**

- In the below image, we will enter the **formula** in **cell**   **C2** and the  **input date**  is given in  **cell B2.**

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-9.png)<figcaption id="caption-attachment-20937">Enter a formula</figcaption>

- It will display the full day name of the specified date.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Example-2-3.png)<figcaption id="caption-attachment-20935">Example 2</figcaption>

### Using WEEKDAY and CHOOSE function:

- You can also use the **[WEEKDAY function](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)** along with the **[CHOOSE function](https://geekexcel.com/how-to-use-choose-function-in-microsoft-excel-2013/)** to get the day of the week in Excel.
- Enter the below formula to get the full day name of the specified date.

**=[CHOOSE](https://geekexcel.com/how-to-use-choose-function-in-microsoft-excel-2013/)([WEEKDAY](https://geekexcel.com/how-to-use-weekday-function-in-microsoft-excel-365/)(B2),”Sunday”,”Monday”,”Tuesday”,”Wednesday”,”Thursday”,”Friday”,”Saturday”)**

- Refer to the below image.
- Here you can see that the **formula**  is entered in the[**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section the  **input date**  is given in  **cell B2.**
- After applying the formula, just click the **ENTER** button to get the result.

![Choose and Weekday function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Weekday-function.png)<figcaption id="caption-attachment-20936">Choose and Weekday function</figcaption>

## More Format Codes:

The below-given table will help to know more format codes in Excel formatting. Make use of it.

| Format

Code

 | Description | Examples |
| --- | --- | --- |
| **0** | It will display the digits in their place. It can force the function to display at least two decimal places. | =**TEXT(18.3012, “$##.00”)**

Output = **$18.30**

 |
| **#** | This will display the placeholder. | 

=**TEXT(5.678, “#.##”)**

Output = **5.66**

 |
| **.** | It shows the position of the decimal point. | **=TEXT(45.4, “0.00”)**

Output = **45.40**

 |
| **d** | Represents the day of the month or day of the week. | =**TEXT([TODAY](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/)(), “dddd”)**

Output = **Monday**

 |
| **m** | It refers to the [month](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/) of the [year](https://geekexcel.com/how-to-use-year-function-in-excel-365/). | =**TEXT(TODAY(), “MM/DD/YY”)**

Output = **01/04/21**

 |
| **y** | [Year](https://geekexcel.com/how-to-use-year-function-in-excel-365/) | =**TEXT(TODAY(), “MM/DD/YY”)**

Output = **01/04/21**

 |
| **h** | [Hour](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/) is represented by one or two-digit number. | =**TEXT(15:20, “hh:mm”)**

Output = **15:20**

 |
| **m** | [Minute](https://geekexcel.com/how-to-use-minute-function-in-excel-365/) | =**TEXT(14:15, “hh:mm”)**

Output = **14:15**

 |
| **s** | [Second](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/) | Nil |

## Bottom-Line:

From this tutorial, we have described the simple steps to get the **Date to Day of the Week in Excel** using the  **TEXT Function**. Hope you like this article. If you have any other **ideas** or question, do share with us here in the **comments** section below. To learn more, check out our website **[Geek Excel!!](https://geekexcel.com/)**

### Read Also:

- **[Convert Date to Month Year Only in Excel Office 365!!](https://geekexcel.com/convert-date-to-month-year-only-in-excel-office-365/)**
- **[Convert Date to Month Day Only in Excel Office 365!!](https://geekexcel.com/convert-date-to-month-day-only-in-excel-office-365/)**