How to create an age calculator in Microsoft Excel.
It is simple to create an age calculator in Excel, if you want to find your age in, Years | Months | Days. Excel is a part of Microsoft Office where you can do accountant, Analytics and other works easily Now, Start How to create age calculate table in several steps,
Step.1
First of all, open Excel and choose a New sheet in it.
Step.2
Create a table and put names of each cell, (Remember that each value should have separate cell)
Make them Bold and align.
step.3
Make the Table colorful, anyway make it beautiful.
Step.4
Put your Name in First cell.
In the Next “Today Date” Cell, if you put Today Date then the next day it remains the same then our age Calculator will Not work
Formula(of the day)
Go in Cell and type =today() and then click Enter, Today date will show. In any day /anytime if you open this sheet Today Date will correctly show.
Step.5
In Date of Birth Cell, First Put the mouse arrow in Date of Birth cell and click the Right Button of Mouse and go to Format cell… and click on the Date And press Enter.
Select the cell>>Mouse right click>>Format cell… >>Date>> Press Enter .
Step .6
Remember These Units,
Step.7
Put the Year Formula Such as;
=DATEDIF(H11;H9;"y") and Press Enter.
In Formula {=DATEDIF( } >> Click the Date Of Birth >> and Today Date then Press Enter.
Step.8
Put the same Formula and only change the “year unit” into “Monthly unit”
=DATEDIF(H11;H9;"ym")and Press Enter
Step.9
Again put the same formula and only change it unit today unit.
=DATEDIF(H11;H9;"md")
Now, Put your date of Birth and see your age…
