Forum Discussion
Convert date and time (00/00/0000, 00:00) to day of the week
Dear All, how do I convert the date and time (00/00/0000, 00:00) which is in one cell to the day of the week (i.e. Mon, Tue, etc.) in another cell? Regards, Chris
Power Query Method
- Format the Date into Excel Table using CTRL + T
- Check my table has headers
- In the Get & transform Data of the Data tab, click on From Table/Range
- Click on the Date dropdown in the Add column tab
- Select Day and Name of Day respectively
Final result in the caption below. Name of Day fully extracted
Next, click on Close & Load in the Home tab