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.