## Find the Last Row of data in Excel

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

Written by kazamraza
no comments

Classified in : Excel Formulas, Lookup Functions

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

Written by kazamraza
no comments

Classified in : Excel Formulas, Date & Time Functions, Visual Basic for Application (VBA)

```
=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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Logical Functions

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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Logical Functions

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

Written by kazamraza
no comments

Classified in : Excel Formulas, Logical Functions

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.