Employee retention 30, 60, 90, 120, 150, 180 and above

[myletterboxnp]

What should be the formula for employee retention for those specific period of time as illustrated in the worksheet? TIA.

 

[Joe4]

Based on that data sample, what do your expected results look like?

 

[myletterboxnp]

I updated the image. I am looking for the number of employees in each category. Thanks.

 

[Joe4]

One easy way would be to use a helper column to count the number of days they have worked, through the current day.
Here is an example:

The formula in cell F2 is:

=IF(E2="",TODAY(),E2)-B2

and copy that down to row F8.

Then the formulas for the counts would be:

For "<=30" days:

=COUNTIFS(F$2:F$8,"<=30")

For ">30 and <=60" days:

=COUNTIFS(F$2:F$8,">30",F$2:F$8,"<60")

and all the ones below it would follow the same pattern, except for the last one.

For ">180" days:

=COUNTIFS(F$2:F$8,">180")

 

[myletterboxnp]

Thank you so much! One last question, Is there a way to pull the names of the employees also in the column C, behind the numbers?

 

[Joe4]

Thank you so much! One last question, Is there a way to pull the names of the employees also in the column C, behind the numbers?

If you are looking for that kind of information, why not just use FILTERS, the new FILTER function, or a Pivot table?

 

[myletterboxnp]

Thank you for all your help. I truly appreciate it.

 

[Joe4]

You are welcome.
Glad I was able to help!