Days of the week - Change 05/03/2010 to Friday

**gadjit** · 03-05-2010, 11:30 AM

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

**Richard Schollar** · 03-05-2010, 11:35 AM

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

**gadjit** · 03-05-2010, 02:01 PM

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


'non working code
Rng.Item(I, 3) = Text(TODAY(), "dddd")

**DonkeyOte** · 03-05-2010, 02:04 PM

We don't know how things have been declared but in general terms:

Cells(1,"A").Value = Format(Date,"dddd")

FWIW you can insert static time stamps natively using CTRL + ; (with Custom Format applied to show as Friday)

**royUK** · 03-05-2010, 02:07 PM

Are you talking about a Formula or VBA?

This should work in VBA

ActiveCell.Value = Format(Date, "dddd")

**royUK** · 03-06-2010, 04:14 AM

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