Forgot to mention that I had already used =TEXT(A1;"dddd"), I just wondered
why the two formulas returned something different.
Thanks to all.

Hans



"Rick Rothstein" skrev i meddelelsen
...
WEEKDAY returns a number, not a date, so your TEXT function call evaluates
to this...

=TEXT(5,"dddd")

but "dddd" is used for dates, not numbers. I think you just want this...

=TEXT(A1,"dddd")

--
Rick (MVP - Excel)


"HK" wrote in message
...
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