WorksheetFunction.IsoWeekNum(Double, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public double IsoWeekNum (double Arg1, object Arg2);

Public Function IsoWeekNum (Arg1 As Double, Optional Arg2 As Object) As Double

Parameters

Arg1: Double

Date-time code used by Excel for date and time calculation.

Arg2: Object

This argument is not available in the function.

Returns

Double

DOUBLE

Remarks

Returns the ordinal number of the [ISO8601] 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.

Applies to

Delen via