| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for day of the week to relate to corresponding date cell
I am not a programmer but can do some basic instructions in excel cells but I
am not able to solve this one. In Excel 2002xp I have a date in one cell and would like this to display the actual weekday in another cell. Is there a formula for achieving this? -- Cadders |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula for day of the week to relate to corresponding date cell
hi,
in A1 is 1/19/08 =text(A1,"dddd")=Saturday =text(A1,"ddd")=Sat regards FSt1 "Cadders" wrote: I am not a programmer but can do some basic instructions in excel cells but I am not able to solve this one. In Excel 2002xp I have a date in one cell and would like this to display the actual weekday in another cell. Is there a formula for achieving this? -- Cadders |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formula for day of the week to relate to corresponding date cell
If your date is in A1, then in B1 enter:
=A1 format B1 as Custom dddd -- Gary''s Student - gsnu200765 "Cadders" wrote: I am not a programmer but can do some basic instructions in excel cells but I am not able to solve this one. In Excel 2002xp I have a date in one cell and would like this to display the actual weekday in another cell. Is there a formula for achieving this? -- Cadders |
| 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 the week and date formula | Excel Discussion (Misc queries) | |||
| formula to relate last cell of info to another cell | Excel Worksheet Functions | |||
| Week number date formula | Excel Discussion (Misc queries) | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Linear Mode
