Tag: excel

Excel – Calculate Age (Years, Months, Days BETWEEN 2 DATES)

=DATEDIF(a1; a2;“y”) OR DATEDIF(a1, a2,“y”) :   (; or ,) ============================================= — =DATEDIF(A1;A2;”y”) & ” years, ” & DATEDIF(A1;A2;”ym”) & ” months,” & DATEDIF(A1;A2;”md”) & ” days” — OR — =DATEDIF(A1,A2,”y”) & ” years, ” & DATEDIF(A1,A2,”ym”) & ” months,” & DATEDIF(A1,A2,”md”) & ” days”