Question: how to subtract dates to get age in excel?
Answer: Formula in B5 calculates age in years, months, and days: =DATEDIF(B2,TODAY(),"Y") & " Years, " & DATEDIF(B2,TODAY(),"YM") & " Months, " & DATEDIF(B2,TODAY(),"MD") & " Days" Formula in B6 calculates age in months: =DATEDIF($B$3,TODAY(),"m") Formula in B7 calculates age in days: