Re-arrange date ranges as per a fortnightly date range list

I would like to request assistance in writing a code or a formula where a date range can be rearranged as per a static list of fortnight dates
Usually I would receive a range of dates and I need to split into the range of fortnights , so that the dates do not overlap or cross over into the next fortnight .




As an example below.

Fortnight dates to refer to

Fortnight Start Date Fortnight End Date
9/02/2022 22/02/2022
23/02/2022 8/03/2022
9/03/2022 22/03/2022
23/03/2022 5/04/2022
6/04/2022 19/04/2022
20/04/2022 3/05/2022
4/05/2022 17/05/2022
18/05/2022 31/05/2022
1/06/2022 14/06/2022
15/06/2022 28/06/2022
29/06/2022 12/07/2022


Raw Data

Start Date End Date
12/02/2022 10/04/2022



Expected Result

Expected Start Date Expected End Date
12/02/2022 22/02/2022
23/02/2022 8/03/2022
9/03/2022 22/03/2022
23/03/2022 5/04/2022
6/04/2022 10/04/2022



Hopefully someone out there knows how this can be done , either with VBA or even perhaps a formula .

Thanks in advance ,
Nyeri

Administrative Note:

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.