WorksheetFunction.IsoWeekNum (Excel)

Returns the ISO week number of the year for a given date.

Returns the ordinal number of the ISO 8601 calendar week in the year for the given date. ISO 8601 defines the calendar week as a time interval of seven calendar days starting with a Monday, and the first calendar week of a year as the one that includes the first Thursday of that year.

IsoWeekNum (Arg1, Arg2)


Dim dblArg1 As Double: dblArg1 = 
Dim dblIsoWeekNum As Double
dblIsoWeekNum = WorksheetFunction.IsoWeekNum(Arg1:=dblArg1)

Arguments

Arg1, Arg2

Arg1 (Double) - Date-time code used by Microsoft Excel for date and time calculation.

Arg2 - This argument is not available in the function