Path: ccsf.homeunix.org!news.moat.net!news.agarik.com!195.166.11.131.MISMATCH!Quza.UK.peer!nntp.gblx.net!ctb-nntp1.saix.net!not-for-mail
From: "Charles" <ce.mason@telkomsa.net>
Newsgroups: fj.comp.applications.excel
Subject: Re: Formula to render day of week
Date: Sun, 8 May 2005 10:07:24 +1100
Organization: The South African Internet Exchange
Lines: 20
Message-ID: <d5khpb$jht$1@ctb-nnrp2.saix.net>
References: <1115498385.298707.234350@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: tkp-ip-nas-1-p222.telkom-ipnet.co.za
X-Trace: ctb-nnrp2.saix.net 1115540075 20029 155.239.165.222 (8 May 2005 08:14:35 GMT)
X-Complaints-To: abuse@saix.net
NNTP-Posting-Date: 8 May 2005 08:14:35 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: ccsf.homeunix.org fj.comp.applications.excel:248

The easiest way would be to create a table with 1 to 7 in the top row and
Monday to Sunday in the bottom row.
Use the formula WEEKDAY() to get the day and then use HLOOKUP() with the day
and your table to get the weekday name.

<sasnet@earthlink.net> wrote in message
news:1115498385.298707.234350@o13g2000cwo.googlegroups.com...
> Perhaps I've miss this, couldn't find what I'm looking for. I want to
> show the text day of the week such as:
>
> 05/05/05 = Friday
>
> All the Date formulas return numbers instead.  Is there a formula or
> other to achieve this?
>
> Thanks,
> SS
>