Assuming your date is in A1...

=TEXT(A1,"dddd")

That spells out the day's name in full... if you ever need the abbreviated
day's name, use only 3 d's instead of 4.

Rick


"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