Week Number (ISO)

=1+INT((A1-DATE(YEAR(A1+4-WEEKDAY(A1+6)),1,5)+WEEKDAY(DATE(YEAR(A1+4-WEEKDAY(A1+6)),1,3)))/7)

Evert van den Heuvel



© Copyright andrewsexceltips.net All Rights Reserved.