ISOWEEKNUM function

Category: Date and time
Introduced: Excel 2013

Summary

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

Syntax

ISOWEEKNUM(date) The ISOWEEKNUM function syntax has the following arguments.
• Date Required. Date is the date-time code used by Excel for date and time calculation.

Example

=ISOWEEKNUM(A2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/isoweeknum-function-1c2d0afe-d25b-4ab1-8894-8d0520e90e0e

Back to Functions