Excel Formula: Convert Date to Text

This tutorial provides the TEXT function to convert a date to text.

If you want to follow along with this tutorial, please download the example spreadsheet.

Generic formula:

Arguments

Return Value

The TEXT function returns to a text value.

How this formula work

To convert the date in cell B3 to a text value, please use below formula:

Press Enter key to get the result.

Explanation

TEXT function: convert a number to a text in a specific format.

Note

Relative Formulas

• Convert date to Julian
  Sometimes, you need to convert the standard date to the Julian date in Excel, here this article introduces a formula which combines the TEXT, YEAR and DATE functions to solve this job.
• Convert date string to datetime
  Sometimes, while you import or paste some datetime data from other devices to Excel, the datetimes maybe not be recognized as proper dates...
• Convert date to year month
  In some cases, you want to convert the date to only month, year, day or monthyear, daymonth, or year day in text format.
• Calculate Hours Minutes Seconds Between Two Times
  Here in this tutorial, it introduces some formulas to quickly present the time difference result as single time unit.

Relative Functions

• Excel IF Function
  Test for specified conditions, then returns the corresponding values
• Excel VALUE Function
  Convert text to number.
• Excel MONTH Function
  The MONTH is used to get the month as integer number (1 to 12) from date.
• Excel DAY Function
  DAY function gets the day as a number (1 to 31) from a date
• Excel YEAR Function
  The YEAR function returns the year based on the given date in a 4-digit serial number format.