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