Formula to help track tenure of employee's

[mrteater]

I am looking for help to track tenure of employee's in my call center. I have a spreadsheet with a sample of data with hire dates. I'd like to track tenure is several categories so I can see if leaders are impacting this stats as we know one of the main reasons employee's leave a job is leadership. Here is what I'm looking to track counts and %

All employee's for overall tenure
*< 12 months
*< 18 months
*< 24 months
*> 24 months

All Production employees tenure (CCR 1, CCR 2, CCR 3)
*< 12 months
*< 18 months
*< 24 months
*> 24 months

[Sam Capricci]

this would be one way with a helper column (that you could hide)...
datedif in the helper column =DATEDIF(B3,TODAY(),"m") dragged down then this countif in col J =COUNTIF($G$3:$G$50,LEFT(I3,4)) then for the percentage in col K
=J3/COUNTA($G$3:$G$50)
the unanswered question would be do you want the counts to be cumulative, so that all those counted in less than 12 months would also be counted along with those counted in less than 18 months. You can also set up what you want for the production employees doing similar things, right now all are included in the counts, you can add an additional factor to either count them only or exclude them or include them.

[Gregb11]

Another option:

All employee's for overall tenure
*< 12 months =SUM(--(EDATE(TODAY(),-12)<$B$3:$B$50))
*< 18 months =SUM(--(EDATE(TODAY(),-18)<$B$3:$B$50))
*< 24 months =SUM(--(EDATE(TODAY(),-24)<$B$3:$B$50))
*> 24 months =SUM(--(EDATE(TODAY(),-24)>$B$3:$B$50))

All Production employees tenure (CCR 1, CCR 2, CCR 3)
*< 12 months =SUM(--(EDATE(TODAY(),-12)<FILTER($B$3:$B$50,LEFT($C$3:$C$50,3)="CCR")))
*< 18 months =SUM(--(EDATE(TODAY(),-18)<FILTER($B$3:$B$50,LEFT($C$3:$C$50,3)="CCR")))
*< 24 months =SUM(--(EDATE(TODAY(),-24)<FILTER($B$3:$B$50,LEFT($C$3:$C$50,3)="CCR")))
*> 24 months =SUM(--(EDATE(TODAY(),-24)>FILTER($B$3:$B$50,LEFT($C$3:$C$50,3)="CCR")))

For percent total, in J3, then copied down:
=J3/COUNTA($B$3:$B$50)

[Gregb11]

Thanks for the rep and feedback!