Excel Formulas to Convert Text into Date Format ~ A Complete Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-05-07 07:46:22

---
title: Excel Formulas to Convert Text into Date Format ~ A Complete Tutorial!!
published: true
date: 2021-05-06 13:47:44 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-convert-text-into-date-format/
---

We have already learned how to **[convert the date into text format in Excel](https://geekexcel.com/excel-formulas-to-convert-date-into-text/)**. Similarly, here we will show the simple formulas used to **convert the text into date format in Excel**. Let’s step into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Convert text to date](https://geekexcel.com/wp-content/uploads/2021/05/Convert-text-to-date.png)](https://geekexcel.com/excel-formulas-to-convert-text-into-date-format/convert-text-to-date/#main)<figcaption id="caption-attachment-36538">Convert text to date</figcaption>

## General Formula:

- You can use the below formula to convert the calendar date into text format.

**=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([LEFT](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/)(text,4),[MID](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)(text,5,2),[RIGHT](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/)(text,2)) **

## Syntax Explanations:

- **DATE**  – In Excel, the **[DATE function](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)** will combine three different values and returns them as a date.
- **RIGHT**  – This function helps to extract the characters from the right side of a text string. Read more on the **[RIGHT function](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/)**.
- **MID**  – The Excel **[MID function](https://geekexcel.com/how-to-use-mid-function-in-microsoft-excel-365/)** is used to extract the number (starting from the left side) or characters from the given string.
- **LEFT**  – It will extract the first character (starting from the left side) or characters from the given string based on the number you specified. Read more on the [**LEFT function**](https://geekexcel.com/how-to-use-left-function-in-microsoft-excel-365/).
- **Text** – It represents the input text on your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B**.
- Now we are going to convert them into normal date format.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-5.png)<figcaption id="caption-attachment-36540">Input Range</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-16.png)<figcaption id="caption-attachment-36539">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-16.png)<figcaption id="caption-attachment-36537">Result</figcaption>

## Bottom-Line:

Hope you like this article on how to **convert the text into the date format in Excel**. Let me know if you have any **doubts** regarding this article or any other article on this site.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Calculate the Years Between Dates ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-years-between-dates/)**
- **[Excel Formulas to Assign Points Based on Late Time ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-assign-points-based-on-late-time/)**
- **[How to Validate Only Numbers in Cell in Excel Office 365?](https://geekexcel.com/how-to-validate-only-numbers-in-cell-in-excel-office-365/)**
- **[Excel Formulas to Apply Conditional Formatting For If Column is Blank!!](https://geekexcel.com/excel-formulas-to-apply-conditional-formatting-for-if-column-is-blank/)**