=TEXT(A10,"DDDDD")

where A10 is the date

"kippers" wrote:

I have been playing round with the WEEKDAY function to convert dates in the
format 1-Apr-06 to digits referring to the day of the week (i.e. 1 to 7).
What is the best way to easily convert these numbers into the actual days of
the week (Monday, Tuesday).

Can I use teh IF function- I started to try this but got a bit stuck:
=IF(WEEKDAY($B2) =1,"Sunday"........

Cheers,