Top Tip 3rd April
How long have I worked here? Excel length of service formula where D5 = Joining date:
=DATEDIF(D5,TODAY(),”y”)&” years, “&DATEDIF(D5,TODAY(),”ym”)&” months, “&DATEDIF(D5,TODAY(),”md”)&” days”
1 January
How long have I worked here? Excel length of service formula where D5 = Joining date:
=DATEDIF(D5,TODAY(),”y”)&” years, “&DATEDIF(D5,TODAY(),”ym”)&” months, “&DATEDIF(D5,TODAY(),”md”)&” days”