Break a date column

Hi everyone i have a table  like below which is the weekly Payroll for each department. In the week ending is always Sunday to indicate the the corresponding week.    I want to transform this table...