How to display only the days of the week?

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
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.?
Click to expand...

One way:
Format the cell, choose Custom, and type in: dddd

=dman=
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Time 6
Summing rows based upon condition 2
Patient Demand on X Day of the Month 4
CALENDAR CREATION 1
Determine day of the week from date 4
Analysis of measured test results by INTERVAL (variable) 2
average if question 2
How to add numbers in adjacent cells 2

Back
Top