Display Weekday Only

E

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.
 
D

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
 
R

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!
==============================================
 
Top