Date format
 

Is there a simple function that will display a date showing the day of the week. For example, if I input 1/8/05 in a cell, could it display as
Monday, 1-Aug-2005

check <format<Cells<Number Date for options
This is display only

"dalymjl" wrote:


Is there a simple function that will display a date showing the day of
the week. For example, if I input 1/8/05 in a cell, could it display
as
Monday, 1-Aug-2005


--
dalymjl

I don't see any option under format/number/date to display the name of the day.

mjd

=WEEKDAY() will return a number representing a day of the week (eg 1 =
sunday, 2 - monday etc)

You could then use a lookup or if statement to turn this into the name
of the day.

R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=392295

<format<cells<number<custom

type dddd, d-mmm-yyyy


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=441466