Display Weekday Only

[echo kilo]

What formula will allow me to display the day of the week only?

For example, I have the date in one column and I would like only the
day of the week in another column.

 

[dominicb]

Good evening echo Kilo

Try this formula:

=TEXT(A1,"dddd")

or use "ddd" in place of the four d's to use the truncated version of a
day (eg Wed).

HTH

DominicB

 

[RagDyer]

Custom format a cell (B1) to:
dddd
And then enter:
=A1
And copy down as needed.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================