Adjusted service date calculation using work relationship history

Summary: We need to use a fast formula to calculate the adjusted service date based on work relationship history. For example, the employee worked from Jan 1 - Dec 31st 2014 and July 1st - Dec 31st 2015, they were rehired on July 1st, 2024. The adjusted service date should be Jan 1st 2023 based on previous work history. How would I create a fast formula to calculate this?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):