How to Return the nth to Last Item in a List in Excel
Usually, you need to return the last or first item in a list, but every once in a while you may find yourself needing to return a...
top of page
Recent Posts
How to Count Colored Cells in Excel
While not a built-in Excel feature, we can create our own function to easily count colored cells. Contents: 1. How to Use VBA User...
How to Highlight Cells Containing a Formula in Excel
To highlight any cell that contains a formula in an Excel workbook, there is a simple conditional formatting formula that can be used....
How to Return the File Pathway of an Excel Workbook Using a Formula
Sometimes you'll find yourself needing to pull a file's pathway into your Excel sheet. Luckily there is a quick formula we can use to...
How to Return the ASCII Number for Every Character in a Cell
The formulas below will take any text input and return the ASCII value of each character that comprises that string. Contents: 1....
How to Round a Date to the First of the Next Month
Contents: Formula Explanation Example - Rounding Dates to First of the Next Month Formula = EOMONTH(date, 0) + 1 By feeding any date into...
How to Round a Date to the First of the Previous Month
Contents: Formula Explanation Example - Rounding Dates to the First of the Previous Month Formula = EOMONTH(date, -2) + 1 By feeding any...
How to Remove Date Data from a Time in Excel
Having dates associated with times in Excel can sometimes throw off time calculations. Luckily, there is an easy way to strip out date...
How to Remove Time from a Date in Excel
Having time associated with dates in Excel can sometimes throw off date calculations. Luckily, there is an easy way to strip out time...
How to Take the Average of Non-Zero Cells in Excel
Using the standard AVERAGE function with data that contains zeros can give you an incorrect average. Instead, we can use the AVERAGEIF...
How to Extract Everything to The Right of a Specific Character in Excel
A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to break up...
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...
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) >...
bottom of page