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