Weekday function question

[Jumi & Shirley Butler]

In my excel worksheet I have a column (say Column A)with a series of
dates (11/30/0l3, 1/10/04, etc). I would like to be able, say in
Column B, to see what day of the week the certain date is. I have
looked thru the instructions for the Weekday function, and it is
beyond me. Can someone give me a simple formula which I can place into
the first cell of Column B and copy all the way down, so that in
Column B it will be a weekday corresponding to the date in Column A?

To reply by mail, remove 'nick'.

Shirley B.

Webmaster:
http://jumi-shirley-butler.com
http://www.geocities.com/mhc_reporter

"Making a way out of no way is sometimes the only way"
Dr. Johnnetta B. Cole

 

[Harald Staff]

Hi Shirley

Weekday returns weekday number. Whan you perhaps want is monday. Try
=TEXT(A1,"dddd")

HTH. Best wishes Harald

 

[Myrna Larson]

In B1 put the formula =A1

and use the custom number format "ddd" or "dddd".

Copy down.

 

[Jumi & Shirley Butler]

Harald, thanks, it works like a charm! Shirl



On Thu, 30 Sep 2004 23:48:20 +0200, "Harald Staff"

~Hi Shirley
~
~Weekday returns weekday number. Whan you perhaps want is monday. Try
~=TEXT(A1,"dddd")
~
~HTH. Best wishes Harald
~
~"Jumi & Shirley Butler" <[email protected]> skrev i melding
~~> In my excel worksheet I have a column (say Column A)with a series
of
~> dates (11/30/0l3, 1/10/04, etc). I would like to be able, say in
~> Column B, to see what day of the week the certain date is. I have
~> looked thru the instructions for the Weekday function, and it is
~> beyond me. Can someone give me a simple formula which I can place
into
~> the first cell of Column B and copy all the way down, so that in
~> Column B it will be a weekday corresponding to the date in Column
A?
~>
~> To reply by mail, remove 'nick'.
~>
~> Shirley B.
~>
~> Webmaster:
~> http://jumi-shirley-butler.com
~> http://www.geocities.com/mhc_reporter
~>
~> "Making a way out of no way is sometimes the only way"
~> Dr. Johnnetta B. Cole
~

To reply by mail, remove 'nick'.

Shirley B.

Webmaster:
http://jumi-shirley-butler.com
http://www.geocities.com/mhc_reporter

"Making a way out of no way is sometimes the only way"
Dr. Johnnetta B. Cole