Help with dates

[AHM]

Hi,

So here is a sample. Employee X was terminated, but then rehired.

I want it as follow 

Before, I used to do this manually on excel. I used to do a pivot table and put "count" to reflect how many lines they have. and then do a VLOOKUP from the pivot table to get the count and if it was more that 1, I would check it manually. 

[danilang]

Hi @AHM 

It would help if you could attach the actual excel file as opposed to just a screen shot

Dan

[AkimasaKajitani]

Hi @AHM 

Is this workflow work well for you?

Input : 

Output :

If you have any questions, please don't hesitate to contact me.

[afv2688]

Hello @AHM ,

how about this?:

Regards

[hike44]

I think you can do it with a pretty simple flow.  I added an extra employee in there ("ZZ") to test for scenario where someone is hired and terminated twice.