T
Tom
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
week, like Monday, Tuesday, ...... etc.?
TIA
Tom
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jon Peltier
Format the cells with a custom number format like "dddd".
- Jon
- Jon
D
Dallman Ross
Tom said: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=
P
Peo Sjoblom
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
data>filter>auto filter, from drop down in the help column select TRUE.
Then select the visible cells (but NOT the headers) and do edit>delete,
select delete entire row. Then remove the filter and the help column
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
data>filter>auto filter, from drop down in the help column select TRUE.
Then select the visible cells (but NOT the headers) and do edit>delete,
select delete entire row. Then remove the filter and the help column
P
Peo Sjoblom
Oops! I misread your question
T
Tom
Thank you all for your kind help.
Regards,
Tom
Regards,
Tom