Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to tell day of week
I have a list of dates and I want to know what day of the week that is. I
have tried WORKDAY and was able to produce numbers between 1-7 (1=Sunday etc) Then I must convert that number to day. Seems way to much to just get the day of week. i.e. A1 B1 (expected result) 2/14/2013 Thursday 3/1/1013 Friday 3/3/2013 Sunday Suggestions appreciated |
#2
|
|||
|
|||
Quote:
Good evening wabbleknee. You´re in the right way. ..........A...................B1---------------------B1 1..02/14/2013.......=WEEKDAY(A1,1)----5 2..03/01/2013.......=WEEKDAY(A2,1)----5 3..03/03/2013.......=WEEKDAY(A3,1)----1 Now that you´ve obtained an answer with the WEEKDAY function, simply FORMAT the result cell, at menu format with: Personalized -- dddd The result will be like this one below: ..........A...................B1 1..02/14/2013.......thursday 2..03/01/2013.......thursday 3..03/03/2013.......sunday Try this one and tell me if it worked for you. Have a nice Day.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to tell day of week
Hi,
Am Thu, 11 Apr 2013 21:02:22 -0400 schrieb wabbleknee: A1 B1 (expected result) 2/14/2013 Thursday 3/1/1013 Friday 3/3/2013 Sunday in B1: =TEXT(A1,"dddd") or =A1 and custom numberformat "dddd" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#4
|
|||
|
|||
Greetings from Brazil
Hi Claus Busch Your suggestion =TEXT(A1,"dddd") is very good. The best of all. Have a nice day.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to tell day of week
Tx, some things are so simple :-)
"Claus Busch" wrote in message ... Hi, Am Thu, 11 Apr 2013 21:02:22 -0400 schrieb wabbleknee: A1 B1 (expected result) 2/14/2013 Thursday 3/1/1013 Friday 3/3/2013 Sunday in B1: =TEXT(A1,"dddd") or =A1 and custom numberformat "dddd" Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
Day Of Week Formula | Excel Worksheet Functions | |||
Formula for end of the week | Excel Discussion (Misc queries) | |||
"If in last week" formula | Excel Discussion (Misc queries) | |||
I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) |