Formula to tell day of week

  • Thread starter Thread starter wabbleknee
  • Start date Start date
W

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
 
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
Click to expand...

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


Regards
Claus Busch
 
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
Click to expand...

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


Regards
Claus Busch
 
Back
Top