age calculator
How do I create an age calculator using 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 The image above , is an embedded Excel Online sheet, so don't hesitate to enter your birthdate in the relevant cell, and you'll be able to determine your age in a moment. The calculator uses the formulas listed below to calculate age based on the formulas below based on 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 have some experience...