Convert date and time (00/00/0000, 00:00) to day of the week

[Chris_Cotterill]

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

[#2]

Repeat this value (=A1) and apply custom format www

[#3]

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?

[#4]

@Chris_Cotterill 

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

[#5]

@Chris_Cotterill 

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