XIRR with dynamic range based on date input (OFFSET)

Hello all, any help with my question is much appreciated.

I have been trying to use the OFFSET function to calculate an XIRR based on an end date specified in the spreadsheet.

In the attached I want to have excel calculate an XIRR based on the start date and cash flows in row 5 and then the end date based on the target date in cell B1.

How do I need to structure the OFFSET formula to do this since the target date cell will be a variable input. So in my example attached the XIRR would calculate from row 5 to row 51 based on the target date of 12/31/2024

Thanks
GGG