Quote:
Originally Posted by 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
|
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, simply 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.