UDF iso Week Number

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 As Long
d2 = DateSerial(Year(d1 - Weekday(d1 - 1) + 4), 1, 3)
IsoWeekNumber = Int((d1 - d2 + Weekday(d2) + 5) / 7)
End Function






Contact us for some advice and guidance on how your Excel development could be created and start helping your business straight away. Contact Us

Datanology