Jan 09 2020 03:13 PM
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
Jan 09 2020 03:29 PM
Jan 09 2020 03:33 PM
Jan 10 2020 01:31 PM
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
Jan 10 2020 02:21 PM
Power Query Method
Final result in the caption below. Name of Day fully extracted
Next, click on Close & Load in the Home tab