ISO Week Count
Cell A1 is January 1 of the year to be calculated.
=- -OR(WEEKDAY(A1)=5,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+11,DAY(A1)+30))=5)+52
© Copyright
andrewsexceltips.net
All Rights Reserved.