Sometime we have a requirement that we want to fetch data from last cell in a column. This task can be achieve by using
Excel formula
=DATEDIF(A2, TODAY(), "y") &" years, "&DATEDIF(A2, TODAY(), "ym") &" months, " &DATEDIF(A2, TODAY(), "md") &" days"
| ◢ | 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.
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.
the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.
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.