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.