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"
