Day of the Week

[Kat5813]

If I have a certain date in a field, say June 12, 2008, is there anyway to
do something that will tell me what day of the week that was.

 

[Kat5813]

I am sorry for the multi post, i didn't mean to post in programming so i was
trying to post it in the right category. The post i got in programming I
don't think will work because I am going to have just about every day of the
year that I need to find the day of the week on so that I can sort on those
results.

 

[Rick Rothstein]

Assuming A1 contains a *real* date...

As a number: =WEEKDAY(A1)

As a text name: =TEXT(A1,"dddd")

 

[Kat5813]

Sorry, I thought your post was the other one and I am not quite sure how I
could make it work but I tried yours and it worked just fine. Thank you so
much for your help. Just a word of advice, be careful how you word things,
your words may come off harsher than you wanted.

 

[Teethless mama]

=TEXT(A1,"dddd")

 

[Bob I]

See, Excel Help, Weekday, Specifically "Show dates as days of the week"