Hi Cyril, why don't you use datedif? such as : If date start in A1 and date end in B1 then in C1 type: =DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" mos "&DATEDIF(A1,B1,"md")&"days" Would that work for you? ReplyCyril...