Day associated with date

[Neal]

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

[Jim Thomlinson]

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

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Jerry]

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" <[email protected]> wrote in message
news:[email protected]...
> 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