Recent Posts

How to Pull Quarters Out of a Date in Excel

When doing any work with dates in Excel, often times you'll want to be able to split up your date into separate quarters. There is no...

The FLOOR.MATH function will round any number down to the nearest integer and if desired, a specific multiple. Contents: Syntax...

The CEILING.MATH function will round any number up to the nearest integer and if desired, a specific multiple. Contents: Syntax...

The MROUND function will round any number up or down to the nearest given multiple. Contents: Syntax Explanation Different Methods of...

How to find the index of the rightmost column in any table or array that has a cell matching a specified value. Contents: Formula...

The ROUNDDOWN function will round any number down to a specified number of digits. This function differentiates itself from the standard...

The ROUNDUP function will round any number up to a specified number of digits. This function differentiates itself from the standard...

The ROUND function will round any number to a specified number of digits. There are plenty of real world situations in which you wouldn't...

Contents: Formula Explanation Example - Rounding Dates to First of the Nearest Month Formula = EOMONTH(date, (DAY(date) >...

The primary use of the TRUNC function is to truncate or remove the fractional part of a number. The function can be configured to remove...

The SMALL function will return the smallest specified number from a given range or data set. For example, SMALL can return the 2nd...

The LARGE function will return the largest specified number from a given range or data set. For example, LARGE can return the 2nd largest...

The INT function will round any input number down to the nearest integer, removing the decimal, or fractional, portion of the number....

The FACTDOUBLE function will return the double factorial of any inputted number. A double factorial is usually notated as any number with...

The FACT function will return the factorial of any inputted number. A factorial is usually notated as any number with a trailing...