Find Returning Employees

I hope you experts can help

I have an EmployeeHistory table with 3 main columns that i want to calculate on. It's a snapshot table, so there are many entries with the same information. 

• EmployeeID
• HireDate
• TermDate

The table has two dimension tables connected to it. Date and Employee. Both of these tables have a 1 to many relationship on the HireDate and EmployeeID and there is also a inactive relationship on the TermDate.

The TermDate is empty if they are still working for us.

I want to calculate when an employee returns to work at the company. This calculation shouldn't show the first HireDate.

Example Table: 

Thanks