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
the webdesigner group security shielf
the webdesigner group logo

Close Button

Web Page Design by

The Web Designer Group