Day associated with date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Calculating calendar days and completion dates. 4
Auto Open macro go to beginning of week 2
Multiple Conditions - VBA 1
Date subtraction 1
Supressing a #VALUE! error returned? 3
Excel 2007 and Security key cards 3
Send email to a email address 7 days before the due date 1

Back
Top