Convert Date to Month & Day Only in Excel Office 365!!
Tags: convertdatetomonthan, excelpreface, excelbasics, exceltutorials
Published: 2021-01-05 15:31:29

---
title: Convert Date to Month & Day Only in Excel Office 365!!
published: true
date: 2021-01-04 15:31:57 UTC
tags: ConvertDatetoMonthan,ExcelPreface,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/convert-date-to-month-day-only-in-excel-office-365/
---

At some point, we only want to use month and day only instead of using the full date format. 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 Month and Day Only in Excel Office 365** using [TEXT Function](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/). Let’s jump into this article.
## Description and Syntax of Text Function:

- The TEXT Function in Excel converts a number to text in the given format.
- If you want to combine numbers with symbols/ text, or you want to display numbers in a more readable format, then this function will be useful in those situations.

**=[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 an example for your reference.

- Here, we are going to change the date ( **mm-dd-yyyy** ) to **mm-dd** format.
- To achieve this, we will use the Text function with this format code (mm-dd).
- You can apply the below formula to get the month and day from the specific date.

**=TEXT(date,”mmmm dd”)**  

- You can see that the **formula** is entered in **cell**   **B3** and the **input date** is given in **cell B2.**

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

- After applying the formula, you need to **click** the **Enter** button to get the result.
- Refer to the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/4.png)<figcaption id="caption-attachment-20675">Output</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(), “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**

 |

## Conclusion:

In this short article, you can easily learn the instructions to **Convert Date to Month and Day Only in Excel Office 365** using TEXT Function. If you have any **queries/suggestions,** kindly drop it in the below comment box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!