Featured Formulas

Calculate days open

In this example, the goal is to calculate the number of days a ticket/case/issue has been open. We start counting on the date a ticket was opened and stop counting on the date a ticket was closed. If there is no closed date, the ticket is still open. Because dates...Read more

Featured Functions

TRIMRANGE Function

The TRIMRANGE function removes empty rows and columns from the outer edges of a range of data. Given a range or array, it will exclude empty rows and/or columns and return a "trimmed" range that contains only data. The beauty of TRIMRANGE is that it will track the data in a worksheet as it...Read more

Recent Articles

My sincere appreciation for the help on this problem. It is a great time saver and I will use this tip literally everyday.
Bob
Thank you. I now can use index match with multiple criteria. I feel i have just jumped to next level Excel expert.
Emily
Awesome! I'm helping with a project and needed to compile 13 employees' working hours, by month, for an entire fiscal year. I started out doing this manually, then found this page. It took a little reworking the function to suit my needs, but when I got it... there was some fist-pumping. You just saved my afternoon!
Chris

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages