Quote Originally Posted by xld
I think this will get you your weeknumber as you define it

=ROUNDDOWN((DAY(B4)+WEEKDAY(B4-DAY(B4)+1)+5)/7,0)
hmmm i got an error, which says: You have entered to few arguments ...

hmm at cell B4 a have the function =NOW() ... so i think this is correct

if i tray to calculate this by hand i can't get it right ... 21 + ( 4-21+1+5 )/7 = 10 / 7 = ...