Thank you all for the feedback here. It was the "automatic" setting that
fixed it.

Also, know I'm not the excelopedia guy. I just love screencasts because they
make it so easy to illustrate a point without tons of text.

"T. Valko" wrote:

You sound like the same person that made the Excelopedia videos.

Set calculation to automatic.

In Excel 2007 that can be done in 2 different places:

Formulas tabCalculationCalculation OptionsAutomatic

Office buttonExcel OptionsFormulasCalculation OptionsAutomaticOK

--
Biff
Microsoft Excel MVP


"Minion" wrote in message
...
I've found many posts on this forum that are related where the
reccommendation is to use the =text(A1,"dddd") to convert a date to the
day
of week.

However, nobody seems to mention the problem I'm seeing when auto filling
the formula down a column to convert a bunch of days. Instead of
converting
the entire column A to day of week in column B ... it returns the same day
of
the week for every date.

I even did a screencast to illustrate what's happening. Am I doing
something
wrong here??

http://screencast.com/t/tUBaYePd0jq