I assume that endDate field is a full date field (day, month, year). If so, please follow your first approach but remove end week number pill from the column shelf.
Then right click on the end date pill and select week number option:
Please note that this will work if your end week number is a regular calendar week not a fancy 'financial' or any other one
if You find this answer helpful please mark it as 'This helped me'