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.

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.

"Kat5813" wrote:

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.

Assuming A1 contains a *real* date...

As a number: =WEEKDAY(A1)

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

--
Rick (MVP - Excel)


"Kat5813" wrote in message
...
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.

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.

"Mike H" wrote:

Yes there is and if you check the post you made in programming you'll find
out how. Please don't multi post

"Kat5813" wrote:

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.

=TEXT(A1,"dddd")


"Kat5813" wrote:

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.

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


Kat5813 wrote:

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.