Formula to tell day of week

[wabbleknee]

I have a list of dates and I want to know what day of the week that is. I
have tried WORKDAY and was able to produce numbers between 1-7 (1=Sunday
etc) Then I must convert that number to day. Seems way to much to just get
the day of week.

i.e.
A1 B1 (expected result)
2/14/2013 Thursday
3/1/1013 Friday
3/3/2013 Sunday

Suggestions appreciated

 

[Mazzaropi]

I have a list of dates and I want to know what day of the week that is.
I
have tried WORKDAY and was able to produce numbers between 1-7
(1=Sunday
etc) Then I must convert that number to day. Seems way to much to jus
get
the day of week.

i.e.
A1 B1 (expected result)
2/14/2013 Thursday
3/1/1013 Friday
3/3/2013 Sunday
Suggestions appreciated

Help from *Brazil*
Good evening *wabbleknee*.

You´re in the right way.
..........A...................B1--------------------->*B1*
1..02/14/2013.......=WEEKDAY(A1,1)---->*5*
2..03/01/2013.......=WEEKDAY(A2,1)---->*5*
3..03/03/2013.......=WEEKDAY(A3,1)---->*1*
Now that you´ve obtained an answer with the WEEKDAY function, simpl
FORMAT the result cell, at menu format with: *Personalized* --> *dddd*

The result will be like this one below:
..........A...................*B1*
1..02/14/2013.......*thursday*
2..03/01/2013.......*thursday*
3..03/03/2013.......*sunday*

Try this one and tell me if it worked for you.

Have a nice Day

 

[Claus Busch]

Hi,

Am Thu, 11 Apr 2013 21:02:22 -0400 schrieb wabbleknee:

A1 B1 (expected result)
2/14/2013 Thursday
3/1/1013 Friday
3/3/2013 Sunday

in B1:
=TEXT(A1,"dddd")
or
=A1 and custom numberformat "dddd"


Regards
Claus Busch

 

[wabbleknee]

Tx, some things are so simple


"Claus Busch" wrote in message
Hi,

Am Thu, 11 Apr 2013 21:02:22 -0400 schrieb wabbleknee:

A1 B1 (expected result)
2/14/2013 Thursday
3/1/1013 Friday
3/3/2013 Sunday

in B1:
=TEXT(A1,"dddd")
or
=A1 and custom numberformat "dddd"


Regards
Claus Busch