| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel and Dates
Is there a formula which will tell me what day of the week a certain fell on?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel and Dates
<Format<Cells
Go to the "Number" tab Click on "Custom" Enter "dddd" (without the quotes) -- Regards, Dave "Cindy Smith" wrote: Is there a formula which will tell me what day of the week a certain fell on? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel and Dates
=WEEKDAY(A1)
outputs the day number (1-7) of the week. If you need the name of the day (Sun-Sat), then use a custom number format of dddd or, use this formula and format as general =TEXT(WEEKDAY(A1),"dddd") "Cindy Smith" wrote: Is there a formula which will tell me what day of the week a certain fell on? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Excel on new computer to show dates like on old | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2003 Trashes Imported Dates | Excel Discussion (Misc queries) | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
Linear Mode
