Calculating days of week

H

HBYardSale

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
 
A

Alf

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.
 
Top