• • • • • • • • • • • • • • • ## EOMONTH Function

Written by kazamraza
Classified in : Excel Formulas, Date & Time Functions Tags : none

Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

## What is logical test in excel?

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

Logical test means a condition when evaluated by computer whose result/outcome is true or false, there is no third option, for example if a student secures more than 45 marks it is considered as pass otherwise fail.

In Excel a single IF function (IF(logical_test, value_if_true, value_if_false)) evaluate only one logical test at one time, if we have more than one conditions/logical tests, then we use AND function or OR function along with IF Function.

Read more What is logical test in excel?

## Find the Last Row of data in Excel Using INDEX and COUNTA

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

Sometime we have a requirement that we want to fetch data from last cell in a column. This task can be achieve by using

• INDEX Function (Return the value or reference of the cell at the intersection of particular row and column in a give range)
• COUNTA Function (Count the number of cell in a range that are not empty)

Read more Find the Last Row of data in Excel Using INDEX and COUNTA