By using our age calculator you can easily calculate the age from date of birth. If you want to know your current age using our birthday age calculator.
You are at the right place if you want to know how old am I at the present date. Our simple date of birth calculation age calculator will calculate your age according to your birth date provided.
Why do you need a birthday age calculator?
Age is one of the important factors in everyone’s life, based on the age you get different benefits different responsibilities and it gives the meaning of life.
In today’s busy life we generally don’t keep track of the dates, especially we miss calculate the age. Many times, we are dependent on smartphones or we use the technology to remind us of the specials dates and events in our lives.
Age of any person will give the idea to plan the present and the future, like when a kid is born in the family you get the complete chart of vaccination based on the age of the child. At what age which vaccination and the food to give to the child can be decided.
As you grow older life takes you through different phases of life. When you grow from the child the age will be based to get into the school.
Different places and different schools have different criteria of admission into the school but if you see the base is the age of the child. You have to be at a particular age to be eligible to get into the school.
Age will determine the eligibility for many things in life like
- Driving license
- Election voter’s eligibility
- Eligible to consume alcohol and cigarettes
- Minimum age to get married (law in some countries) and many more.
How simple birthday age calculator works
As the name tag says it is a very easy and simple calculator to calculate the exact age. You have to specify your date of birthday,
Click on the Input box -> make the selection from the days, month and year options. Once you have selected your date of birth or the date of birth of your friend or anyone you want to calculate the age, click the calculate button to get the result at the bottom.
In the result section, you will be given with details like
- Your age at the present date (How to write age in years and months)
- Calculate Your age in months
- Find Your age in weeks
- Know Your age in days
- Shows Your age in hours
- Your age in minutes
- Your age in seconds and milliseconds
Along with this, you will be given a beautiful graphical presentation of the calculation where it shows how many days were passed the last birthday you have celebrated. How many days are left for the next birthday for the celebration. How many days for the next birthday, so you can plan the birthday event accordingly using our date of the birth calculator.
How to calculate the age in excel
If you wondering how the age is calculated and don’t want to use the internet to get you the answer then you can do it on your own by using Microsoft Excel application.
The basic formula to calculate the age at the present date, considering the number of days in a year 365 days is as
Today’s date – Birthdate / 365
In excel you can type the formula in formula bar as
= (today() – A1) / 365
Where A1 is the cell value in which the date of birth is entered
Other than using the basic formula excel to calculate the age MS excel provides two other mathematical functions to calculate the number of years between two given dates, for eg.,
- YEARFRAC()
- DATEDIF()
Calculate the age from the date of birth using excel YEARFRAC Function
The basic syntax of the function is
YEARFRAC(start_date, end_date, [basis])
Where start_date we will give as the date of birthdate,
End_date is the present date when calculating the formula for eg. Today()
[basis] is the type of count basis to use
Example of the use of the formula is
=yearfrac(A1, today(),1)
Calculate the age from the date of birth using excel DATEDIF() function
This function is one of the excel function which is a very powerful function to calculate the difference between the two dates. However, this function cannot be seen in the functions list, that is why most of the people think that it is not available in their version of MS Excel. But, if you use the function will all the fields you will get the result.
The basic syntax of the function is
DATEDIF(start_date, end_date, unit)
Where start_date could be the date of birth or any date which is earlier than end_date
End_date could be the date of present-day or the date of which you want the difference
Unit is used to specify the unit to calculate the difference between dates
| Unit | Meaning | Explanation |
| Y | Years | Return the number of years between the dates |
| M | Months | Returns the number of months between the dates |
| D | Days | To get the number of days between the dates. |
| MD | Days excluding years and months | Returns the days without considering year and months. |
| YD | Days excluding years | Return the number of days without considering the years |
| YM | Months excluding days and years | Returns the number of months without considering the days and years |
Examples of the formula
=datedif(A1, today(),”d”)
The above formula returns the number of days between the dates in cell A1 and today’s date
Here is more detailed information about the human body growth and its development, which give you more in-depth knowledge of our body and its growth.
Calculate age from date of birth chronologically
What is the meaning of chronological? It is a phrase to present the stages of anything happened in the past for example in the life cycle of a human being we can use this to represent the stages of life which is life chronologically.
Giving you a clear picture of how many days,months years you have lived and if you wan to be more precise you can break it down to seconds and milliseconds.
Conclusion:
If you find the above information is helpful please share it with your friends and family. comment below your feedback and suggestions.