Formula to tell day of week

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
 
C

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
 
W

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top