age calculator
How can I create an age calculator in Excel? Excel Now that you know how to make an age formula in Excel, you can build a custom age calculator, for example this one:https://onedrive.live.com/embed?c What you see above , is an embedded Excel Online sheet, so you can enter your birthdate in the relevant cell, and you'll get your age in just a second. Calculators use the following formulas to compute age based on the "" date of birth in cell A3 and the date of birth in cell A3 and the date of today. 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: =DATEDIF($B$3,TODAY(),"d") If you've got some experience usi...