Products, services, and OS functions
may not be available in this country.

ISOWEEKNUM

The ISOWEEKNUM function returns the ISO (International Organization for Standardization) week number for a specific date.

ISOWEEKNUM(date)

date: A cell reference containing a date or a function that returns a date.

Notes

  • ISOWEEKNUM uses the ISO 8601 standard.

Examples

If A1 contains 2022-03-01:

=ISOWEEKNUM(A1) returns 9.

If A1 contains 3, A2 contains 1, A3 contains 2022, and A4 contains =DATE(A3,A1,A2):

=ISOWEEKNUM(A4) returns 9.

See alsoDATE
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.