Tag Archives: UDF iso weeknumber

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 […]

the web designer group uk
the webdesigner group logo

Close Button

Web Site Designed by

The Web Designer Group