Calculate Age Using DATEDIF Function

Written by kazamraza no comments

Excel Formula


=DATEDIF(A2, TODAY(), "y") &" years, "&DATEDIF(A2, TODAY(), "ym") &" months, " &DATEDIF(A2, TODAY(), "md") &" days"

 

 

Example
A B C D E
1 Data Formula Result    
2 06-Jun-90 =DATEDIF(A2, TODAY(), "y") &" years, "&DATEDIF(A2, TODAY(), "ym") &" months, " &DATEDIF(A2, TODAY(), "md") &" days" 30 years, 0 months, 17 days    
3          
4          

 

Note: Today date is assumed as 23/Jun/2020.