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...
top of page
Recent Posts
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.
bottom of page