Day of week Fill down column not working

  • Thread starter Thread starter Minion
  • Start date Start date
M

Minion

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
 
Make sure that you have calculation set for automatic.

Tools|Options|calculation tab in xl2003 menus.

Somewhere under the Excel Options in xl2007.
 
Do you have recalculation set to automatic? If not, that could be your
problem.
Are you filling down both columns A and B? You have to fill down column A so
that column B refers to something.

Finally, while =text(...) is often suggested, if you don't need two columns
worth of data, don't bother with this solution. Simply format column A as
"dddd". This will display the day of the week for you, and fill down without
any problems.

Regards,
Fred.
 
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 tab>Calculation>Calculation Options>Automatic

Office button>Excel Options>Formulas>Calculation Options>Automatic>OK
 
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.
 
Back
Top