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
 
N

Nick Hodge

J

See possible reply in programming

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning a Date with Multiple Criteria Lookup Values 0
Search closest day in the past from today 2
Unhide column difficulty 3
week numbers 7
Formula to tell day of week 3
Fiscal Year Week Number Calculation with a twist.... 6
Multiple fields under X-axis, but only first field gets the right 0
Calculating End Date - Given working 4, 5, 6, or 7 day workweek. 9

Top