Tuesday, 10 August 2021

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"



No comments:

Post a Comment