Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting Date to Day of Week
Is there a function that will take a date (eg. 10/20/05) and yield the corresponding day of the week? -- QuestGAV ------------------------------------------------------------------------ QuestGAV's Profile: http://www.excelforum.com/member.php...o&userid=17432 View this thread: http://www.excelforum.com/showthread...hreadid=478135 |
#2
|
|||
|
|||
Converting Date to Day of 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 QuestGAV wrote: Is there a function that will take a date (eg. 10/20/05) and yield the corresponding day of the week? |
#3
|
|||
|
|||
Converting Date to Day of Week
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 "QuestGAV" wrote in message ... Is there a function that will take a date (eg. 10/20/05) and yield the corresponding day of the week? -- QuestGAV ------------------------------------------------------------------------ QuestGAV's Profile: http://www.excelforum.com/member.php...o&userid=17432 View this thread: http://www.excelforum.com/showthread...hreadid=478135 |
#4
|
|||
|
|||
Converting Date to Day of Week
Beautiful, thanks! -- QuestGAV ------------------------------------------------------------------------ QuestGAV's Profile: http://www.excelforum.com/member.php...o&userid=17432 View this thread: http://www.excelforum.com/showthread...hreadid=478135 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Converting Date to Work Week... | Excel Discussion (Misc queries) | |||
52 week average based on date | Excel Discussion (Misc queries) | |||
How can I convert a date into a week number... | Excel Worksheet Functions | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |