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.