how to insert day of the week

18-May-06 07:16:02
You can apply a custom format and have the date/day in the same cell:



format|Cells|number tab|custom category:



mmm dd, yyyy ddd

for 3 character day



mmm dd, yyyy dddd

for the complete spelling of the day







Or with the date in A1, you could use an additional cell:

=a1

and format as ddd or dddd



or

=text(a1,"ddd")

=text(a1,"dddd")















--



Dave Peterson
reply
 
 

how to insert day of the week

18-May-06 07:16:40
You've got other replies at your other post.











--



Dave Peterson
reply
 

how to insert day of the week

18-May-06 07:18:43
Oops.  I didn't notice that it was cross posted.



















--



Dave Peterson
reply
 

how to insert day of the week

18-May-06 01:13:31
TEXT(NOW(),"ddd")
reply
 

how to insert day of the week

18-May-06 09:07:19
I use win xp home edition, sp2, excel 2003



Can someone tell me how I can insert day of the week next to my date,



example May 18, 2006 Thurs
reply
 
promotion
Silverlight    WPF    WCF    WWF    LINQ   
JavaScript    AJAX    ASP.NET    XAML   
C#    VB.NET    VB 6.0    GDI+    IIS    XML   
.NET Generics    Anonymous Methods    Delegate   
Visual Studio .NET    Expression Blend    Virus   
Windows Vista    Windows XP    Windows Update   
Windows 2003 Server    Windows 2008 Server   
SQL Server    Microsoft Excel    Microsoft Word   
SharePoint    BizTalk    Virtual Earth   
.NET Compact Framework    Web Service   

"Everything" RSS / ATOM Feed Parser
How to send and receive messages through message queuing in .Net
How to Read text file as database
SQL Server 2005 Paging Performance Tip
Display code of web page.
Fully Scalable Excel File Importer class for .net using Microsoft Jet driver
Generic Chart Color Manager class that can be used for any charts
Helper class to style the infragistics wingrid
Using Reflection to detemine as Assembly Info in and out.
Helper class to play with Window (Owners and position)
Resolving displayname from the culture using the XmlLanguage and LanguageSpecificStringDictionary class