We need to calculate the week number in the year of each day, and it requires to use multi-row formula tool to select all that apply:
I have tested all of the options, but only answer C is correct.
Day of Week(1-7) is the same week.
The test result shows that my answer was wrong. Is there anyone who can help me double check is there any correct answer?
