Converting Date to Day of Week

  • Thread starter Thread starter QuestGAV
  • Start date Start date
Q

QuestGAV

Is there a function that will take a date (eg. 10/20/05) and yield the
corresponding day of the week?
 
If you an answer like "Thursday" then:
=TEXT(A1,"dddd")
or you can use the WEEKDAY function to return the day of the week
=WEEKDAY(A1)
1 = Sunday, 2 = Monday etc.

Hope this helps
Rowan
 
Hi!

A couple of ways:

A1 = 10/20/2005

=TEXT(A1,"dddd")

Will return the TEXT value Thursday

Another way:

=A1

And custom format the cell as dddd

Using this method the true underlying value of the cell is the date serial
number but it's just DISPLAYED as Thursday.

Biff
 
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

Problem formatting dates from CSV file 2
Formula to tell day of week 2
convert date to Day of the Week 2
Lookup next item with dates 4
Date, Day of week 6
Assign each week number to corresponding month of the year 5
Calulating week # & Day # 2
number of week days in a period of time 5

Back
Top