How often do we wonder how old an object might be or what the exact age of a person could be! We have compiled 3 fun ways you can figure out the age of the particular person or object in question.
So let’s kick off, shall we!
1: Online age calculators
You can bet that technology always has our back. It solves a lot of our problems from critical ones to trivial ones. if you want to calculate your age to surgical precision for whatever reasons, be they critical or trivial, you can use an online age calculator to measure your age accurately.
The good thing about an online calculator is that all you have to do is feed it with your date of birth and it would calculate your age in years, months, weeks, days, hours, minutes and up-to seconds. This method of figuring out your age is appropriate if you want to measure your own age or the age of another person or object to absolute precision.
2: Calculating age with MS Excel
Our second best bet is the Microsoft Excel, it’s a tool by Microsoft that is used for various purposes like accounting, statistics and other operations that involve listings. It uses different formulas as operators on the variables you feed it.
It can also determine your age and has various functions for the intended purpose. However, we’d be discussing the DATEDIF function for simplicity.
Here’s the formula:
DATEDIF(start_date, end_date, unit)
The variables it uses are self-explanatory, for the first variable i.e. start_date, you have to input your date of birth and for the “end_date,” you have to use the present date, i.e. the date on which you decide to measure your age on Excel.
The unit refers to the gauge in which you want to measure your age. If you want to measure your age in years, then simply use ‘y’ for unit. And it will calculate your age, simple as that.
But what if you want to calculate age to a little more precision than years alone, well, we’ve got your back with additional formulas:
If you want the result in number of months: DATEDIF(B2, TODAY(), “YM”)
If you need to get the result in number of days: DATEDIF(B2,TODAY(),”MD”)
Whereas B2 is the date of birth.
Then, unify these functions in one formula, like this:
=DATEDIF(B2,TODAY(),”Y”) & DATEDIF(B2,TODAY(),”YM”) & DATEDIF(B2,TODAY(),”MD”)
3: The way of the Math
The most obvious way would be to subtract the person’s birth year from the present year. It works!
Subtract 1 if you haven’t yet had your birthday in the present year. This works as long as you were born in the same century in which you’re calculating your age, that would be the 21st century, this is an obvious limitation of this method. The reason being that you’re really only dealing with a two-digit subtraction. For instance, if the year is considered to be 1996 and the person calculating their age, was born in 1945, you simply subtract 45 from 96 and you’d get 51.
Sarahwrites 