Assigning week number with weekending on Sundays..
I have a requirement where in i have to assign weeknumbers starting from 1. The weeks would end on Sundays. This needs to be done for year 2009.But the 1st day of 2009 didn't start on monday.So if we consider that week monday fell on 29th Dec. So i want to assign that week as week no 1 and so on..