Calculate Age From a Date of Birth in Excel (DATEDIF Function)
Everyone has one. Even dogs have one. In this video you'll learn how to calculate age from the date of birth using DATEDIF, a super-secret Excel function, so secret that it doesn't appear in Excel's Functions drop-down list!
So whether you need to calculate the age of a person in whole years or the age of a puppy in weeks, check out this short video.
For full details see the timestamps below:
⏱ Timestamps
00:00:00 Introduction
00:00:28 Use the DATEDIF Function to Calculate Age in Years
00:02:22 Use the DATEDIF Function to Calculate Age in Weeks
00:03:31 Use the INT Function to Fix the Rounding Problem
🗒 Notes and Resources
Download a copy of the files used in this video: https://share.getcloudapp.com/RBum0vpk
The formulas that I used in the demos:
=DATEDIF(C2,TODAY(),"Y")
=INT(DATEDIF(A2,TODAY(),"D")/7)
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #datedif #age