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.