Excel Formulas to Convert Date into Text ~ A Complete Guide!!
Tags: excelformula, excelformulas
Published: 2021-05-04 12:40:38

---
title: Excel Formulas to Convert Date into Text ~ A Complete Guide!!
published: true
date: 2021-05-04 08:04:27 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-convert-date-into-text/
---

When we work in often Excel, we deal with numbers, texts, and date format. In Excel, the date & time are stored as numbers and converted to readable values based on the formatting. Here we will show the simple formula to **convert the date into text format**. Let’s begin!! 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 date into text](https://geekexcel.com/wp-content/uploads/2021/05/Convert-date-into-text.png)](https://geekexcel.com/excel-formulas-to-convert-date-into-text/convert-date-into-text/#main)<figcaption id="caption-attachment-35227">Convert date into text</figcaption>

## General Formula:

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

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

## Syntax Explanations:

- **TEXT ** – In Excel, the **[TEXT function](https://geekexcel.com/list-of-text-functions-in-microsoft-excel-365/) **helps you to simplify things when you come across data that has too much text.
- **Date ** – It represents the input dates from your worksheet.
- Format – It specifies which format you want to display your date.
- **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 dates in **Column B**.
- Now we are going to get the date in text format **(like 30/04/2021 as 30 April 2021)**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-6.png)<figcaption id="caption-attachment-35229">Input Ranges</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-6.png)<figcaption id="caption-attachment-35228">Enter the formula</figcaption>

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

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

## Bottom-Line:

Hope you like this article on how to **convert the date into text 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. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**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/)**