## EOMONTH Function

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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Date & Time Functions

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.

Written by kazamraza
no comments

Classified in : Excel Formulas, Date & Time Functions

Sometimes we need start date and end date of a month for our financial model. We can solve this problem by using EOMONTH Function.

Read more How to Get Start Date end Date of a Month Form a Date

Written by kazamraza
no comments

Classified in : Excel Formulas, Logical Functions

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.

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

**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

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