How to Calculate Age in Excel
How to Calculate Age Using a Date of Birth in Excel
Welcome! This post offers a step-by-step guide on how to calculate age using a date of birth in Excel.
You can simply calculate the exact number of years that have passed between a given birth date and the present. It’s a lot easier than you think! Let’s get started.
Hello! And welcome to TechZahi Academy! My name’s Jaina and together with our TechZahi team, we’re here to make sure you’ll be able to use Excel in a quick and easy way, thanks to our digestible post.
How to Use Function “DATEDIF”
The DATEDIF function in Excel is the most appropriate for calculating age. Make sure the data table is properly formatted before using the function.
The cells with dates must be formatted as Date and the cells to display the calculated age need to be formatted as Number.
Choose the cell to display the result, write the equal sign, and then type ‘DATEDIF’.
Now we need to enter three details.
The first is Date of Birth, so click in cell D3, then add a comma, and Excel now requires the current date.
How to Combine DATEDIF and TODAY Functions in Excel
This can be easily entered as TODAY Function.
write ‘TODAY’ and continue by adding the opening and closing brackets.
This command will ensure that Excel will always use the current date for its calculations, making the result always up to date.
If you need to use a date other than the current one, you can save it in a different cell and refer to it in the formula, exactly like we did with Date of Birth.
Since we want to use the current date, we’ll leave the function TODAY in the formula and move on to the next step.
To discover the precise number of completed years that passed between the date of birth and today’s date, add another comma and continue entering Y in quote marks for years. Simply close the brackets and press the ‘Enter’ key.
Excellent work!
How Can Simply Be the Function Used in the Other Rows in Excel
The function can be used to calculate age in the other rows, too. Simply copy the formula from the first cell by dragging down the bottom left corner of that cell. And that’s all it takes!
Each row now contains the calculated age as the number of completed years that passed between the date of birth and today.
To find out the exact number of days or months, read our posts on how to calculate the difference between two dates in Excel. Check out the link here! If you found this post helpful, give us a like and read other posts by TechZahi Academy.
Learn how to use Excel quickly and easily! Is this your first time on TechZahi? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the TechZahi!
Thanks for reading and I’ll see you in the next post!