age calculator
How to 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 below is an embed Excel Online sheet, so do not hesitate to input your birthdate within the appropriate cell and you'll find your age in a moment. Calculators use these formulas to calculate age in relation to the age of the date of birth in cell A3 as well as the current date. 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 have some experience working with Excel Form controls...