Thank you, Mr. daddylonglegs for your time and sharing your knowledge with me. I used your formula: =MAX(0,SUM(IF(MOD(COLUMN(D3:J3)-COLUMN(D3),2)=0,IF(D3:J3<>"",YEAR(IF(E3:K3,E3:K3,TODAY())+1)-YEAR(D3:J3-1)-1))))

confirmed with CTRL+SHIFT+ENTER
but I am getting a #VALUE error on Ford, Musco's years of service. Shouldn’t I get in return a value of 4 years of service instead?
Again, this forum wouldn’t be the same without you guys.