How to Use ISOWEEKNUM Function

The ISOWEEKNUM function returns the number of the ISO weeks in a given date.

Formula:

=ISOWEEKNUM(date)

Explanations:

Date is required, the date you want to find the number of ISO weeks.

Cautions:

  • Dates are stored as sequential numbers and January 1, 1900 is serial number 1.
  • Long years have 53 weeks, and short years have 52 weeks.

Download: ISOWEEKNUM Function

Leave a Reply