Recent Posts

Multi-Sheet References & Formulas - 3-D References in Excel

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

How to Calculate the Number of Days in a Month From a Date

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

How to Return the End of the Month From A Date in Excel

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

How to Get the First Day of the Month From A Date in Excel

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

How to Extract The Year From any Date in Excel

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

How to Extract The Month From any Date in Excel

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

How to Extract The Day From any Date in Excel

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

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

Finding the Rightmost Column Containing a Specific Value in a Table or Array

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

How to Round a Date to the First of the Nearest Month in Excel

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

How to Get a Sheet Name Using a Formula in Excel - 3 Methods

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 by Row in Excel

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

How to Update Pivot Table Data Sources on New & Copied Workbooks with VBA

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

How to Perform Mathematical Operations Using Paste

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