Hi,

Try to formate the cell that give you "1900-01-05 00:00" to General.
That should work for you.

Arne Hegefors skrev:

Yes thanks but there seems to be some trouble. In cell A1 I have: 2006-01-01.
In another cell I write: =WEEKDAY(A1;2). the return value I get is:
1900-01-05 00:00.
(I have the Swedish Excel version ). It does not seem to give me what I
want..please help me out!

"tony h" skrev:


The weekday function will give you a mon-sun indicator

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=567795