Weekday Code for Large Number of Dates

[mlarson]

I am using the following formula to show the weekday in a given cell. Assume the date is in column A (example: 1-10-2011 in A1) and the output is in column B (example: Monday in B1).

=CHOOSE(WEEKDAY(A1), "Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

My question is if I have a large number of dates in column A how can I automatically have the day of the week output in column B without copying the formula in each cell in column B?

Thank you.

 

[njimack]

Why not just use =TEXT(A1,"dddd") or =A1 (formatted as "dddd")

 

[jmthompson]

Do you need the call to actually contain the day of the week or do you need it to display the day?

you could use =A1 in B1 (fill down) and then use a custom format on column B of [$-409]dddd

Otherwise, you could use VBA

 

[jmthompson]

Why not just use =TEXT(A1,"dddd") or =A1 (formatted as "dddd")

even better, duh

 

[mlarson]

Do you need the call to actually contain the day of the week or do you need it to display the day?

I only need it to display the day. I would prefer that the output in column B not contain the formula, but rather just the day of the week.

What would be the VBA code using =TEXT(A1,"dddd") as the formula?