Birth Date Calculation in Excel

Open Excel Sheet

Age Differnce from Current Date

Enter your date of birth in A1 Field format(mm-dd-yyyy)

Copy and paste the below formula in A2 Field

=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months, "&DATEDIF(A1,TODAY(),"md")&" days"

Age Differnce from paricular date

Enter your date of birth in A1 Field format(mm-dd-yyyy)

Enter the particular Date in A2 Field

Copy and paste the below formula in A2 Field

=DATEDIF(A1,A2,"y")&" years, "&DATEDIF(A1,A2,"ym")&" months, "&DATEDIF(A1,A2,"md")&" days"