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

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

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=

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

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

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