Age Calculation

If your Date of Birth is in A1 then Use below formula to Calculate Age,

0 Year 0 Month 0 Days,

=DATEDIF(A1,TODAY(),"Y")&" Year "&DATEDIF(A1,TODAY(),"YM")&" Month "&DATEDIF(A1,TODAY(),"MD")&" Days"

0 Year 0 Month,

=DATEDIF(A1,TODAY(),"Y")&" Year "&DATEDIF(A1,TODAY(),"YM")&" Month "

Only Year,

=DATEDIF(A1,TODAY(),"Y")&" Year "       

                              or

=DATEDIF(A1,TODAY(),"Y")