Changing dd/mm/yy to the day of the week

  • Thread starter Thread starter Gerald
  • Start date Start date
G

Gerald

Hi,

Am looking for a macro or whatever which will change a set
of dates into the corresponding week day. Ie: I have a
column of dates in this format: 01/01/03 thru to 16/10/03.
I want to write a quick macro which will then drop into an
adjacent cell, the day of the week that each day is, so in
column 'A' we have the dates (01/01/03) and in column 'B'
we have the day that that date was ie Wednesday.

any help would be great.

cheers
 
Hi,

Am looking for a macro or whatever which will change a set
of dates into the corresponding week day. Ie: I have a
column of dates in this format: 01/01/03 thru to 16/10/03.
I want to write a quick macro which will then drop into an
adjacent cell, the day of the week that each day is, so in
column 'A' we have the dates (01/01/03) and in column 'B'
we have the day that that date was ie Wednesday.

any help would be great.

cheers
Click to expand...

Try this:

Activecell.NumberFormat = "dddd"

CoRrRan
 
You could insert a new column, then copy column A to column B and format column
B to show the date, but even simpler is to just format column A to show both the
date and day of week.

as a macro:
ActiveSheet.Range("a:a").NumberFormat = "mm/dd/yyyy* dddd"

But you could just format the column manually, too:
Select your range
format|cells|Number Tab|
Custom
mm/dd/yyyy* dddd

The asterisk-space tells excel that you want the mm/dd/yyyy left justified, but
the dddd right justified.

(I like this one!)
 
Back
Top