How to Calculate Age Using a Date of Birth in Excel | Excel Tutorials for Beginners

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:

#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

[jlyxkmd]

=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.

[Aravindhv]

If we want to caluculate other than today pls u can help me with the formula.

[Aravindhv]

Hi instead of today wr wan to calcululate on some other date then what will be the formulae