How to convert dates from numeric values to text

As a Sales Manager, a report which allows you to see how sales perform on different days of the week could be useful to you; enabling you to make informed business decisions on weekly stock orders. The TEXT function converts a numeric value to text, so you can set dates to display as text to make it easier to see days of the week; i.e. Monday February 2013 as opposed to 2013/02/11.

Note: Download the sample workbook to practice this exercise.

Applies to: Microsoft® Excel® 2007, 2010 and 2013.
The screen shots below will be used to illustrate this exercise.


1. To extract the week day from the date string, select TEXT under the Formulas tab as below.













2. Select cell C3 and enter as per the screen shot below.


3. Select OK and copy the formula down.

4. To extract the day, month and year from a date string.

a. Select cell D3 and as follow the instruction in step 2 above.

b. Enter as per screen shot below.
tip-4c. Select OK and copy the formula down.

5. The data will be displayed as per screen shot below.


For more information on extracting the day, month and year using the TEXT function, refer to the screen shot below.