Categorys per job title and Years of service

[Charlene Durand]

I need a formula to help me with the category's to be placed into a coloum per person:

Increases was done in June, employees were split into job descriptions & period of service


Category A 0 – 2 years
Category B 2 - 5 years
Category C greater than 5 years

 

[etaf]

hows is the service arrived at 0 do you have date started - so a number can be calculated

also a sample spreadsheet

 

[Charlene Durand]

yes it is a formula

=IFERROR(IF(DATEDIF($V598,$BP598,"y")=0,"",DATEDIF($V598,$BP598,"y")&"y ")&IF(DATEDIF($V598,$BP598,"ym")=0,"",DATEDIF($V598,$BP598,"ym")&" m "),IF(DATEDIF($V598,TODAY(),"y")=0,"",DATEDIF($V598,TODAY(),"y")&"y ")&IF(DATEDIF($V598,TODAY(),"ym")=0,"",DATEDIF($V598,TODAY(),"ym")&" m "))