The formula :=WEEKNUM(A2)-WEEKNUM(MONTH(A2)&"/1/"&YEAR(A2))+1

returns a 2 for the date 1/2/2012, which should be a one, then boosts every thing up a week, so 1/30 returns a 6? So it appears there is an issue with that formual, will continue to investigate...