Kazam Trainings

Excel Formula

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

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

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

the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.

Read more OR Function

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.

Read more IFERROR Function

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