| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
One way:
Format the cell as "dddd" In article , GRE wrote: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
Another way: =VLOOKUP(WEEKDAY(F16),H7:I13,2,FALSE) where the date appears in
F16, and the table H7:I13 is a table showing the day number of the week (Sunday = 1, etc. and the corresponding day)... But of course this is much more complicated than JE McGimpsey's method.... -- Brevity is the soul of wit. "JE McGimpsey" wrote: One way: Format the cell as "dddd" In article , GRE wrote: |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007)
Another way:
A1 = 1/1/2007 =TEXT(A1,"ddd") returns Mon =TEXT(A1,"dddd") returns Monday Biff "GRE" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check input is a date | Excel Discussion (Misc queries) | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Desperately need help with 3 calculations | Excel Worksheet Functions | |||
| Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
| Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005? | Excel Worksheet Functions | |||
Linear Mode
