You could simply format the same column. If, however, you insist on having
the day in a separate column:
1. insert a column next the the column having the date value
2. insert a formula which simply equates the new column to the original column
3. select the entire new column or the used range in the new column
4. format the cells using custom format with format string "dddddd"

"RickyDee" wrote:

I have an ACCESS database that I copied over into EXCEL for ease. Now I have
a date such as 04/08/2005. I'd like to somehow add a column for the day of
the week that this is, or add the day to this particular column and I'll use
a delimiter or something to separate it. In the end, I'd like to have a
separate column for the day.
Thank you,
Rick