| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Day of Week
Is there a way to identify the day of the week from a cell with the
date. Eg. Jan 20, 2008 in cell A1 with a formula in cell A2 that displays Sunday. Regards, Frank |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Day of Week
Two ways...
1) Put = A1 in A2 and use dddd as the custom format 2) Put =TEXT(A1, "dddd") in A2 The first one still has the date actual date in it, just formatted to look like the day name (notice the word Sunday is on the right side of the cell just like a number would be). The second one is text only. Rick wrote in message ... Is there a way to identify the day of the week from a cell with the date. Eg. Jan 20, 2008 in cell A1 with a formula in cell A2 that displays Sunday. Regards, Frank |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Day of Week
On Jan 20, 6:56*pm, "Rick Rothstein \(MVP - VB\)"
wrote: Two ways... 1) Put = A1 in A2 and use dddd as the custom format 2) Put =TEXT(A1, "dddd") in A2 The first one still has the date actual date in it, just formatted to look like the day name (notice the word Sunday is on the right side of the cell just like a number would be). The second one is text only. Rick wrote in message ... Is there a way to identify the day of the week from a cell with the date. Eg. Jan 20, 2008 in cell A1 with a formula in cell A2 that displays Sunday. Regards, Frank- Hide quoted text - - Show quoted text - Thanks for your help. Frank |
| 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) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| group sales by week and week number | Excel Discussion (Misc queries) | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Linear Mode
