I recently had 2 requests for help with generating a list of weekdays for the current year. In the first request, all that was required was a list of dates in column A and a list of days in column B. The second request was a bit more complex as the customer wanted to exclude the UK holidays.
In this video I cover both requests in detail: