How to Calculate Ages in Microsoft Execel

 

How to Calculate ages in Microsoft Execel

Formula 1 :

<//=YEARFRAC(B2, TODAY(), 1)

Formula 2 :

<//=DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days"