On Sat, 27 Feb 2010 08:11:51 +0100, "HK" wrote:

Hi Ron
On a second thought I see it like this:

With 27-Feb-2010 i cell A1 the formula =TEXT(WEEKDAY(A1,1),"dddd") returns
Saturday (DK: lørdag) which of course is correct. But I think that this
correctness is a consequence of two (according to DK standards) false
assumptions. First the weekday part of the formula should be WEEKDAY(A1;2)
because here Monday is the first day of thee week. The second thing is that
(as far as I can see) Excel always, irrespective of location, consider
Sunday as the first day of the week. If i F9-analyze the WEEKDAY(A1;1) part
of above formula with 27-Feb-2010 in A1 I see 7. But here Saturday is
weekday number 6.

That's why
=INDEX({"Monday","Tuesday","Wednesday","Thursday" ,"Friday","Saturday","Sunday"};WEEKDAY(A1,2)
also returns correct result because here I use 2 as second argument in
WEEKDAY function and Monday as first day of week.

Are we saying the same or do you think I am wrong?

I think you are wrong and are not understanding, among other things, how Excel
stores dates.

But I don't have time right now to explain. I'll check back later.
--ron