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

IF Function

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

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.

So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

Read more IF Function