Trick 002: Find any day of the year with Power Query.

 In the process of working, from the initial data we want to find a specific day of the year. We want to know what day of the week it is? .....

      This is a good example to find any day of the year. In a single column of dates you can find the last Monday of that year.