How to Calculate Age Using a Date of Birth in Excel | Excel Tutorials for Beginners
Vložit
- čas přidán 13. 09. 2024
- In this video I have explained how you can calculate age by using Datedif function in excel. This function basically calculate number of years from date of birth, further you can modify same function to get age in months as well days. Watch this video till end for better understanding.
Learn advance excel by visiting our below website:
alichaudary.com
#Calculateage #Exceltutorial #Learnforfuture
Below topics are covered in this video
1. How to Calculate age using Datedif function
2. How to Calculate age from date of birth in excel
3. How to Calculate age in months
4. How to Calculate age in days
5. How to count age in excel
=DATEDIF(E3,J3,"Y") - an example if calculating for dates other than today. Just put =DATEDIF ([select the cell you want] comma [select other date cell] comma "Y"). Should do it. In this example I was calculating age at a specific dated event.
thank you
Hi instead of today wr wan to calcululate on some other date then what will be the formulae
If we want to caluculate other than today pls u can help me with the formula.