Find the ISO weeknumber of a date

All ISO-weeks have 7 days and begin on a Monday. Week 1 begins on the monday of the week in which the first Thursday of the year falls. This means that week 1 can start in the year before, and week 52 or 53 can end in the year after!

We use a formula to calculate the weeknumber of the date listed in field A1: