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