The Week() function "restarts" at 1 every year, so you cannot use this if the two dates span two years. No, I would probably do
(WeekStart(Today()) - WeekStart(Date))/7
instead. To understand what this does you need to understand how QlikView handles dates. Read about this here. But to make a long story short: The WeekStart() function returns an integer corresponding to the day. So by taking the diff and dividing by 7, you get the number of weeks ago.