| 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 |
| 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) | |||
Threaded Mode
