Day associated with date

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

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

No need for a macro. In cell B1, use the formula =A1, and copy down to match
your column A. Then format the cells for custom, using dddd to show the
day name.

HTH,
Bernie
MS Excel MVP

"Neal" <Neal@discussions.microsoft.com> wrote in message
news:5B324F0F-EAD8-4695-BA2A-66FDF30C3319@microsoft.com...
> 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

Neal,

I use the formula in column b for each cell =weekday(a1,1); where a1=a date
and the 1 denotes the start day of the week as Sunday=1 thru Saturday=7; use
2 for Monday=1 thru Sunday=7; use 3 for Monday=0 thru Sunday=6.

Jerry

"Neal" <Neal@discussions.microsoft.com> wrote in message
news:5B324F0F-EAD8-4695-BA2A-66FDF30C3319@microsoft.com...
> 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