PC Review


Reply
Thread Tools Rate Thread

How to display only the days of the week?

 
 
Tom
Guest
Posts: n/a
 
      5th Sep 2007
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 With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      5th Sep 2007
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
>



 
Reply With Quote
 
Dallman Ross
Guest
Posts: n/a
 
      5th Sep 2007
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=

 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      5th Sep 2007
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
>



 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      5th Sep 2007
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
>>

>
>



 
Reply With Quote
 
Tom
Guest
Posts: n/a
 
      6th Sep 2007
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
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:44 PM.