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.

TRUE Function

Written by kazamraza no comments
Classified in : Excel Formulas, Logical Functions Tags : none

Returns the logical value TRUE. You can use this function when you want to return the value TRUE based on a condition. For example:


=IF(A1=1,TRUE())

 

You can also enter the value TRUE directly into cells and formulas without using this function. For example:


=IF(A1=1,TRUE)

 

If the condition is met, Excel returns TRUE in both examples. If the condition is not met, Excel returns FALSE in both examples.

Read more TRUE Function