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
4 Replies
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
- Repeat this value (=A1) and apply custom format www
- Thank you Segei. Could you be a bit more detailed...
What do you mean by:
=A1
custom format www
how do I apply the format?First
Stay on B1 and Ctrl+1, here
use dddd format (sorry, I misprinted in previous post). Result is
If you need weekday as text (not as dated formatted for weekday) you may use
=TEXT(A1,"dddd")as here in C1
