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.