WEEKDAY
HK wrote:
In A1 I have: 26-Feb-2010
Formula:
=INDEX({"Monday","Tuesday","Wednesday","Thursday", "Friday","Saturday","Sunday"};WEEKDAY(A1,2))
returns Friday
whereas formula:
=TEXT(WEEKDAY(A1,2),"dddd") returns Thursday.
(Second argument in WEEKDAY is 2 because here Monday is first day of week)
Why is it that the two formulas return different results?
Hans Knudsen
Try this instead:
=TEXT(A1,"dddd")
|