USE THE TEXT FUNCTION TO EXTRACT DATE PARTS - DATE AND TIME FUNCTIONS - MICROSOFT EXCEL

USE THE TEXT FUNCTION TO EXTRACT DATE PARTS USING MICROSOFT EXCEL

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 formatted as shown in the screenshot below.

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->.

USE THE TEXT FUNCTION TO EXTRACT DATE PARTS USING MICROSOFT EXCEL

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 be formatted individually.

Watch the Video Tutorial - https://www.youtube.com/watch?v=5kvFLr2MjqI

 

Use custom formatting to display the day of the week - Date and Time Functions - Microsoft Excel Tutorials

Use custom formatting to display the day of the week Using Microsoft Excel

How to show the day of the week in Microsoft Excel. A worksheet contains dates in Column A. Use this tip to get the corresponding day of the week of these dates.

To display weekdays using customized formatting:

1. Select cells B2:B10 and type the formula =A2.
2. Press <-Ctrl+Enter->.
3. From the Format menu, select Cells.
4. Select the Number tab and click on Custom below Category.
5. In the Type box, change the number format to "dddd".
6. Press OK.

Watch the Video Tutorial - https://www.youtube.com/watch?v=lkEw0eHF2O0