excel if date range is between date range return value

Hi I am looking for some help with a spreadsheet im working on. I have a list of locations with a start and end date and I want to seperate these locations into tax years.

The end result will be a number of tables showing journeys completed within tax years. If a location falls into a tax year for instance 20/21 the entry should have a start date of the later of the actual start date or 06/04/2020.

Im self taught in excel and am comfortable with formulas or VBA so any help would be appreciated.

I have included a picture below of the sample data and also the desired outcome.

Sample data and desired result