Display Weekday Only
 

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.


--
echo kilo
------------------------------------------------------------------------
echo kilo's Profile: http://www.excelforum.com/member.php...o&userid=24972
View this thread: http://www.excelforum.com/showthread...hreadid=384976

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=384976

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


"echo kilo" wrote
in message ...

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.


--
echo kilo
------------------------------------------------------------------------
echo kilo's Profile:
http://www.excelforum.com/member.php...o&userid=24972
View this thread: http://www.excelforum.com/showthread...hreadid=384976