Recent Posts

A 3-D reference is a reference to a range of cells across multiple worksheets in a workbook. For example, if you have a workbook with...

A quick way to return the number of days in any given month using a formula. Contents: Formula Explanation Formula = EOMONTH(date,0) -...

Here is a quick formula that will allow you to return the end of the month from any date in Excel. Contents: Formula Explanation Example...

Here is a quick formula that will allow you to return the beginning of the month from any date in Excel. Contents: Formula Explanation...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a couple different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different...

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

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

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

When working in a workbook with a lot of different tabs, being able to pull, reference, and use specific sheet names can save you a lot...

How to sum across multiple dynamic arrays in a dynamic, flexible formula using the BYROW and LAMBDA Functions.

When copying workbooks, sometimes Pivot Tables/Caches Won't update and link properly, here's a work around.

How to add, subtract, multiply, and divide any size range without the need to create extra columns. All with paste.