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.
 

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
Finding the week of date 4
filter due this Week ,next week, > nextweek 2
Spreading date range across days in weeks (advanced) 7
14 Day Average 4
5 working days of a week 4

Back
Top