Detect employee actual entry data and exit date

Hi everyone,

I have a employee database, structure as below:
- Each movement of employees will be created as new row in database
Eg. Employee A, move from team "Engineering 1" to "Data Science" with the entry date = exit date + 1

- Blank cell in Exit date means Active employee
- Employee "E" left, then came back after several months

Now, I want to have the actual entry date and actual exit date as what column F and G show.
Could anyone please help? Thank you so much.

Sample Data:

Screenshot 2024-09-30 at 14.48.08.png