• • • • • • • • • • • • • • • ## Calculate Age Using DATEDIF Function

Written by kazamraza
Tags : none

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

## IFERROR Function

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

You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.