Day of the Week Calc in Excel

D

deacs

In Excel, is it possible to return the day of the week if I have a lis
of dates? Any guidance on how to accomplish this will be greatl
appreciated.

Thanks in advance,
j
 
B

Biff

Hi!

You can display the weekday by changing the cells format.
If the dates you have listed are true Excel dates just
select those cells and goto Format>Cells>Number tab.
Select Date and choose the format that displays the
weekday.

Or, if you want to keep the list of dates as is and in an
adjacent cell display the weekday do this:

Say the cell in question is A1. In B1 enter =A1. Now goto
Format>Cells>Number tab. Select Custom and in the little
text box enter dddd.

Or, you can even do it using a formula but I would use one
of the above methods.

Biff
 
D

Derrick

Try =text(A2,"ddd") for day of wk short text
and =text(A2,"dddd") for day of wk long text
 
Top