age calculator
How to make 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 The image in the above image is an Excel Online sheet, so take the time to enter your birthdate in the corresponding cell, and you'll discover your age within a matter of seconds. The calculator utilizes the following formulas to calculate age using the web page's date of birth in cell A3 and 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 with Excel...