Thanks guys..another user said to use Format, Cell, Number, Date and click
on the second option that includes the day with the date.

"bigwheel" wrote in message
...
Hi, =TEXT(A1, "dddd") if your date is in A1

"HT" wrote:

**cross post from microsoft.public.excel**..no answer as of yet

Excel 2003
WindowsXP

I am creating a spreadsheet and inserting many dates. I want to insert
the
date and have the day of the week of that particular date appear.
Otherwise
I would have to look up years worth of dates.

Is there a way to do this?

Thank you.