date problem

[Len Case]

Hi all,,,,,,,,,could someone help me with this one please.
I have a column of dates, thus 20 june 2009
25 june 2009
30 june 2009
As you can see not all are consecutive. Is there any way I can insert the
day, either by formating or some kind of code.?
Thanks
Len

 

[Don Guillett]

Look in the help index for TEXT or format as "ddd"

 

[Rick Rothstein]

What do you mean by "insert"? It is always a good idea to give examples so
that we don't have to guess. Are you looking to make this cell value...

20 june 2009

look something like this?

Saturday, 20 June 2009

If so, just click Format/Cells on the menu bar, select Custom from the
left-hand list and type the following into the Type field...

dddd, d mmmm yyyy

 

[DILipandey]

Hi Len,

Supposing you have the dates in column A from A1 onwards, type in the
following formula in column B, respectively:-
=TEXT(A1,"DDD")
or =TEXT(A1,"DDDDD").

If you want the day to appear in column A itself, where original dates are
present, they try following format:-

Select the column A, go to Format -> Cells and choose following "custom"
format:-

DDD
or
DDDDD

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India