The easiest way would be to create a table with 1 to 7 in the top row and
Monday to Sunday in the bottom row.
Use the formula WEEKDAY() to get the day and then use HLOOKUP() with the day
and your table to get the weekday name.

<sasnet@earthlink.net> wrote in message
news:1115498385.298707.234350@o13g2000cwo.googlegroups.com...
> Perhaps I've miss this, couldn't find what I'm looking for. I want to
> show the text day of the week such as:
>
> 05/05/05 = Friday
>
> All the Date formulas return numbers instead.  Is there a formula or
> other to achieve this?
>
> Thanks,
> SS
>