Hi Team,

I have to add attached Date table to extract payroll data. I am struggling with pay week as it was incorrectly numbered in this year. 

From next year, I would like to have the correct pay week number. However in order to extract previous data, I will have to have a date table exactly the same as last year pay week numbering.

Please have a look for the attached file and intended result to be appeared as date table in power query.

Thanks for your help.

Regards,

Aye