Converting a date to the day of the week

[Donna J.]

I have a date in my spreadsheet that I would like to be
converted to the day of the week. For example, I have
08/06/04 in cell E7 and would like the result to come
back in another cell that it is Friday. I can not seem
to get the formula =weekday(E7) to show anything other
than 6 ((which I believe equates to Friday)). Thanks!

 

[JulieD]

Hi Donna

here's two methods for you depending on what you're really after

one method (this just changes the format)
click in the cell that you want to know the day in
type =E7
then right mouse click on it
choose
format cells
under the number tab choose
custom
type dddd
click ok

another method:
=VLOOKUP(WEEKDAY(E7,2),{1,"Monday";2,"Tueday";3,"Wednesday";4,"Thursday";5,"
Friday";6,"Saturday";7,"Sunday"},2,0)

Cheers
JulieD

 

[Frank Kabel]

Hi
use the formula
=E7
and format this cell with the custom format
"DDDD"

or use the formula
=TEXT(E7,"DDDD")

 

[Bob Phillips]

=TEXT(E7,"ddd") to show Fri or

=TEXT(E7,"dddd") to show Friday

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Donna J.]

Thanks Frank. Have a GREAT day

-----Original Message-----
Hi
use the formula
=E7
and format this cell with the custom format
"DDDD"

or use the formula
=TEXT(E7,"DDDD")


--
Regards
Frank Kabel
Frankfurt, Germany


.