WorksheetFunction.IsoWeekNum method (Excel)
Returns the ISO week number of the year for a given date.
Syntax
expression.IsoWeekNum (Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Arg1 | Required | Double | Date-time code used by Microsoft Excel for date and time calculation. |
| Arg2 | Optional | Variant | This argument is not available in the function. |
Return value
Double
Remarks
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.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for