Excel formulae working in one excel sheet but not another one in exactly the same layout

I was struggling to get excel to return a formula so I asked a colleague but took out all real data as HR-related. I'm trying to work out years and months for the length of service. So I sent it to c...