Microsoft Excel Functions & Formulas

Use the TEXT function to extract date parts

A worksheet contains date values in column A as text that cannot

be interpreted by Excel as date values. As in the previous example,

the text has to be extracted, but the result should be specially for-

matted as shown in the screenshot below.

4

To extract, combine, and show specially formatted date:

1. Select cells B2:B10 and type the following formula:

=TEXT(DATE(RIGHT(A2,4),MID(A2,3,2),

MID(A2,1,2)),"YYYY-MM-DD").

2. Press <Ctrl+Enter>.

Note: First, transfer the last four digits with the RIGHT

function. Then use the MID function twice to get the two

digits for month and day. With the TEXT function the date can ...