Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display only the days of the week?
I have a column of dates. How can I make it to display only the days of the
week, like Monday, Tuesday, ...... etc.? TIA Tom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display only the days of the week?
Format the cells with a custom number format like "dddd".
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tom" wrote in message .. . I have a column of dates. How can I make it to display only the days of the week, like Monday, Tuesday, ...... etc.? TIA Tom |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display only the days of the week?
In , Tom
spake thusly: I have a column of dates. How can I make it to display only the days of the week, like Monday, Tuesday, ...... etc.? One way: Format the cell, choose Custom, and type in: dddd =dman= |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display only the days of the week?
If you put a date in a cell and copy drag down the cell using the right
mouse button you will get an option to fill weekdays only. For dates that you already have in place you could use a help column and a formula like =WEEKDAY(A2,2)5 copy down, select all values including the help column, apply datafilterauto filter, from drop down in the help column select TRUE. Then select the visible cells (but NOT the headers) and do editdelete, select delete entire row. Then remove the filter and the help column -- Regards, Peo Sjoblom "Tom" wrote in message .. . I have a column of dates. How can I make it to display only the days of the week, like Monday, Tuesday, ...... etc.? TIA Tom |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display only the days of the week?
Oops! I misread your question
-- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... If you put a date in a cell and copy drag down the cell using the right mouse button you will get an option to fill weekdays only. For dates that you already have in place you could use a help column and a formula like =WEEKDAY(A2,2)5 copy down, select all values including the help column, apply datafilterauto filter, from drop down in the help column select TRUE. Then select the visible cells (but NOT the headers) and do editdelete, select delete entire row. Then remove the filter and the help column -- Regards, Peo Sjoblom "Tom" wrote in message .. . I have a column of dates. How can I make it to display only the days of the week, like Monday, Tuesday, ...... etc.? TIA Tom |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to display only the days of the week?
Thank you all for your kind help.
Regards, Tom "Tom" wrote in message .. . I have a column of dates. How can I make it to display only the days of the week, like Monday, Tuesday, ...... etc.? TIA Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort days of week | Excel Discussion (Misc queries) | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
COUNTIF by days of week | Excel Worksheet Functions | |||
7 days of the week | Excel Discussion (Misc queries) | |||
Days of the week. | Excel Worksheet Functions |