Tx, some things are so simple :-)


"Claus Busch" wrote in message ...

Hi,

Am Thu, 11 Apr 2013 21:02:22 -0400 schrieb wabbleknee:

A1 B1 (expected result)
2/14/2013 Thursday
3/1/1013 Friday
3/3/2013 Sunday

in B1:
=TEXT(A1,"dddd")
or
=A1 and custom numberformat "dddd"


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2