Easily identify the iso weeknumber with a formula. Paste this UDF into a module in the VB Editor (ALT+F11) then use the following formula on a worksheet. =isoweeknumber(A1) This will return the iso week number that cell A1 falls under – ie 01/03/2017 = week 9 Public Function IsoWeekNumber(d1 As Date) As Integer Dim d2 […]
