Why a Macro?
In column B reference the adjacent cell column in (In B2 make the Formula =A2)

Now reformat A2 as a Custom Format "DDDD"

Or if you need the Text String Friday use the Weekday function in B2 and do
a lookup of that value.

HTH

"Neal" wrote:

Hi,

Column "A" contains dates. I would like a macro that will scan that column
and then put each dates associated day of the week in column "B".

TIA