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

SEARCH Function

The SEARCH function returns the position (as a number) of one text string inside another. In the most basic case, you can use SEARCH to locate the position of a substring in a text string. You can also use SEARCH to check if a cell contains specific text....Read more

Recent Articles

Thank you for the "errors" function. It saved my life yesterday! When you don't often work on some formulae, then you forget!
Karla
Greatly appreciate your website - love your philosophy - many thanks. Australia :)
Richard
I've been using your site for reference as I learn more advanced functions/features of Excel. Your materials are very well written and informative.
Michael

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