Hi,
Is it possible to display the day of the week in cell i.e FRIDAY instead of 05/03/2010
thanks in advance for any help on this.
regads
Steve
Hi,
Is it possible to display the day of the week in cell i.e FRIDAY instead of 05/03/2010
thanks in advance for any help on this.
regads
Steve
Last edited by gadjit; 03-05-2010 at 02:21 PM.
Hi
You could just change the formatting of the cell eg to custom of
dddd
Or you could use a formula if you don't already have a date and want a text value:
=TEXT(TODAY(),"dddd")
Richard
Richard Schollar
Microsoft MVP - Excel
thank you, is there a way to add the date without it changing each day?
how would i add this using VB script as this format will not work
Please Login or Register to view this content.
We don't know how things have been declared but in general terms:
FWIW you can insert static time stamps natively using CTRL + ; (with Custom Format applied to show as Friday)Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Are you talking about a Formula or VBA?
This should work in VBA
Please Login or Register to view this content.
Last edited by royUK; 03-05-2010 at 02:35 PM. Reason: typo
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks