Hello Heinz,
On Sun, 23 Nov 2003 00:33:39 +0100 (23.11.2003 04:33 my local time)
you wrote about "Week of the year"
at least in part:
HH> So all weeks where the 01.01 between monday and thursday are the
HH> first week of the year.
But what is the number of week for 01 Jan after Thursday?
%WEEKOFYEAR("31.12.2005")
%WEEKOFYEAR("31.12.2003")
produce now
1
53
in my code now, %WEEKOFYEAR("1.1.2006") - 1
52
52
53
53
53
53
for
%WEEKOFYEAR("26.12.2003")
%WEEKOFYEAR("27.12.2003")
%WEEKOFYEAR("28.12.2003")
%WEEKOFYEAR("29.12.2003")
%WEEKOFYEAR("30.12.2003")
%WEEKOFYEAR("31.12.2003")
--
Best regards,
Alexander Leschinsky
- MOTD:
I said to my girl, 'Was it good for you too?' And she said, 'I don't think this was
good for anybody.'
Gary Shandling
________________________________________________________
http://www.silverstones.com/thebat/TBUDLInfo.html
