Just a quick tip for excel. To receive current week number use formula
=TRUNC(((TODAY()-DATE(YEAR(TODAY());1;0))+6)/7)