How to display only the days of the week?

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:uHFDi.19999$(E-Mail Removed)...
>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
>

's Computer Specifications

In <uHFDi.19999$(E-Mail Removed)>, Tom
<(E-Mail Removed)> 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=

's Computer Specifications

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

--
Regards,

Peo Sjoblom

"Tom" <(E-Mail Removed)> wrote in message
news:uHFDi.19999$(E-Mail Removed)...
>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
>

's Computer Specifications

Oops! I misread your question

--
Regards,

Peo Sjoblom

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
>
>
> "Tom" <(E-Mail Removed)> wrote in message
> news:uHFDi.19999$(E-Mail Removed)...
>>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
>>
>
>

's Computer Specifications

Thank you all for your kind help.

Regards,
Tom

"Tom" <(E-Mail Removed)> wrote in message
news:uHFDi.19999$(E-Mail Removed)...
>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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display days of the week	=?Utf-8?B?Q29uZHVjdG9yMTU=?=	Microsoft Outlook Calendar	1	6th Apr 2006 08:07 PM
Display days of week in 7 columns	=?Utf-8?B?TGl6enk=?=	Microsoft Outlook Calendar	1	12th Jan 2006 02:01 AM
Display days of the week	=?Utf-8?B?THVuYQ==?=	Microsoft Outlook Calendar	1	17th Jun 2005 02:03 AM
Calendar Display Days of the Week	=?Utf-8?B?TWljaGFlbCBPeGZvcmQ=?=	Microsoft Outlook Discussion	1	21st Oct 2004 08:37 PM
Display Days of the Week	Ged	Microsoft Outlook Calendar	2	14th Jun 2004 02:04 PM