Finding the project status at the time when date changes are made

Hello,

I have two tables that pull history of a project.

• Table 1: Target End Date Field - shows the date/time when that field was changed
• Table 2: Project Status - shows the date/time when the project changed statuses (Definition, Discovery, etc.)

I provided an image below to hopefully explain this better, but what I needed help on was trying to see if there is a way to find the status of the project at the time the target end date field was changed.

For example, the image I attached below shows the target end date field was changed on 5/16/2024.  I wanted to create a column to show that during this time, the project status was in Implementation (the project entered Implementation status on 2/27/2024 and didn't transition out until 9/11/2024.) - Thank you for your help!