Week Numbers
Key points
- Choose WEEKNUM
- Choose the week start
- Copy it
In WEEKDAY Builder you can build a formula for the week of the year.
Steps
- Choose WEEKNUM
- Choose the week start
- Copy it
ISO gives the international standard week number.
Use "Build a WEEKDAY Formula" (free)
Tools that go well with this
- Build a Date Offset Formula: Build date offset formulas.
- Build a DATEDIF Formula: Build a DATEDIF formula.
- Build a NETWORKDAYS Formula: Build working-day formulas.