Calculating days of week

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HBYardSale - 19 Apr 2004 00:09 GMT

This should be a simple one, but can't find it in any of the help menus....

In column A, I have a list of dates, like 4-13-04.
In column B, I would like the day of the week to be displayed.

I found this, which returns a "1" for Sunday, "2" for Monday, etc., but can't
figure out how to get it to automatically display the name of the day.

=+WEEKDAY("4-13-04")

Many thanks in advance!

-- J

Reply to this Message

Nick Hodge - 19 Apr 2004 00:29 GMT

J

See possible reply in programming

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> This should be a simple one, but can't find it in any of the help menus....
>
[quoted text clipped - 9 lines]
>
> -- J

Reply to this Message

Alf - 20 Apr 2004 20:09 GMT

A quick and dirty way to get it done is to have another
support table in the workbook with 1-7 in a column and
Sun-Sat in the column next to it. Label this list as
DOW, and use a Vlookup of the number from your date to
convert to the text day.

>-----Original Message-----
>J
[quoted text clipped - 18 lines]
>
>.

Reply to this Message