age calculator
How to make 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 in the above image is an Excel Online sheet, so take the time to enter your birth date in the appropriate cell, and you will discover your age in just a few seconds. The calculator utilizes the formulas listed below to calculate age according to the web page's date of birth in cell A3 as well as today's 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've had some experience...