How to Use ISOWEEKNUM Function

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




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


  • 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