Hi,
If your date is in A1 then:
=WEEKDAY(A1)
you will need to format the cell to show only the day.....in cell
format select custom and type dddd

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=475201