Work with dates
Find the week number of a date
=ISOWEEKNUM(A2)How it works in Excel
- ISOWEEKNUM gives the week of the year, using the international standard.
- Under this standard, weeks start on Monday.
- WEEKNUM uses a different rule and can differ by one.
The idea in general
It says how far through the year a date falls, counted in weeks.
What I assumed
- The date is in A2.
Check the result on your own data before relying on it.