Day of the Week

  • Thread starter Thread starter Kat5813
  • Start date Start date
K

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.
 
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.
 
Assuming A1 contains a *real* date...

As a number: =WEEKDAY(A1)

As a text name: =TEXT(A1,"dddd")
 
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.
 
See, Excel Help, Weekday, Specifically "Show dates as days of the week"
 
You must log in or register to reply here.

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

Similar Threads

Day of the Week in Excel 2
Auto calculate day of week to week of the year (not as serial) 4
Dates and days of the week 3
Spreading date range across days in weeks (advanced) 7
Finding the week of date 4
filter due this Week ,next week, > nextweek 2
14 Day Average 4
5 working days of a week 4

Back
Top