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?
If it is an certification question, we are not allowed to answer it.