If A1 contains a "legal" XL date, in B1 enter
=A1
And custom format B1 to
ddd
OR
dddd
--

HTH,

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

"larry" wrote in message
...
What i am trying to do is put in date ie:- 30/12/07 and have sunday.
=a1(date)b2(day)
Thanks for any larry