Weekday formula

[brianwa]

Can anyone help with the weekday formula.
What I want to do is enter the date in say A1 11/20/2003 and have B
return the answer of Thursday. Currently I use the weekday formula bu
only returns the number of the day.

Thanks in advance
B

 

[Chip Pearson]

There are several ways to do this. One is to enter =A1 and format the cell
with a custom number format of dddd. Another way is to use the function
=TEXT(A1,"dddd").


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Jason Morin]

The easiest way is just to use =A1 in cell B1 and custom
format B1 as "dddd" under Format > Cells > Number tab.

Or use this in B1:

=TEXT(A1,"dddd")

HTH
Jason
Atlanta, GA

 

[BrianB]

1. You can custom format the cell as dddd (1900 date system)
2. Have a range (here called "days") with the 7 days of the week an
use something like :-
=INDEX(days,WEEKDAY(A1)

 

[brianwa]

Thanks Brian,

That worked except I had to add -1 to the end of the formula.
For some reason the Weekday returned todays day (ie your formul
returned today as saturday)

=index(a1:a7,weekday(b1-1))

thanks again for your help

B