Tag Archives: identify working week in excel

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

Close Button

Web Page Design by

The Web Designer Group