date format and day of week

[James]

I downloaded a file into excel that has a column of dates (ex., 10/20/2007).
I then formatted this column to the same date format. My goal is to have a
column that shows the corresponding day of week (ex., Saturday). In another
cell (ex., C2), I entered "=B2" (the corresponding date) and did a custom
format as "dddd". But when I hit "enter", it returns the original 10/20/2007.
The kicker here is when I go into that cell and physically retype
"10/20/2007", then cell C2 shows what I'm looking for (Saturday). I don't
want to go in and retype all of the dates as there's many thousand. How do I
fix?

 

[Bob Phillips]

Not the 'proper' way to do it (as there is still the fundamental problem),
but how about using

=TEXT(B2,"dddd")