Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Day of week Fill down column not working
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate working days but change working week | Excel Discussion (Misc queries) | |||
How do I use the WORKDAY function for a six-day working week? | Excel Worksheet Functions | |||
5 working days of a week | Excel Discussion (Misc queries) | |||
working out a date for a fixed day of the week | Excel Worksheet Functions | |||
Count working days by week | Excel Worksheet Functions |