Hello,
I am a basic user of office 365, and have basic knowledge of creating an excel spreadsheet.

I am creating an annual accounting spreadsheet, and would like to have each table headed by the week number corresponding to the British tax year which is from the 4th April to the 3rd April of the following year, which means 52 weeks (Sunday to Saturday).

The two tasks I want to do are as follows:

Create a list of dates
(April 4rd 2020 to April 3rd 2020) which look like this:

Wk 1 –29 March 2020 – 4th April 2020
Wk 2 – 5th April 2020 – 11th April 2020
Wk 3 – 12th April 2020 – 18th April 2020
Continue till Wk 53

Automation
My 2nd query relates to automation. I was planning on copying and pasting the dates from this created list, but is there any way I could automate the process? The dates will not be in a continuous list. I will have 53 accounting tables on a long excel sheet. The dates were meant to be the header for each table, so they will at the top of each table.
Is there some formula I can insert in the cell where I want the dates above to show? If I auomtate it, then I’d like to be able to do it each year for 2021 onwards. Otherwise, I will have the tedious job of copying and pasting each year.

If anyone can help, I’d appreciate concise easy to understand instructions. Thanks in advance.