Attached is an example, with 2 formulas - one uses ISO week definition, another US week definition (and according WEEKDAY() function parameters). The result is same of-course.
The start date is Monday of week, where Start Date defined on Sheet SetUp belongs to.
|