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 2004 - 2010, andrewsexceltips.net All Rights Reserved.