Quote Originally Posted by daddylonglegs
Yes, as of 1st January 2008 that will give you a negative number. How do you define your week numbers? Does week 1 always start on the 1st of June and last 7 days? If so you could use a formula like

=INT((TODAY()-DATE(YEAR(edate(TODAY(),-5)),6,1))/7)+1
The fiscal year always starts on the first friday of June. So how can I change the formula to reflect that?