1 January

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”