Featured Formulas

Date and Time

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

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

TEXTAFTER Function

The Excel TEXTAFTER function extracts text that occurs after a given delimiter. When multiple delimiters appear in the text, TEXTAFTER can return text that occurs after the nth instance of the delimiter. TEXTAFTER can also extract text after a specific delimiter when counting...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I really enjoy your site. I'm fairly proficient with excel, but I always use your site as a resource for those formulas that I don't use on a regular basis. Keep it up!
Ryan
I was searching around for about 45 minutes, trying to find a simple way to count the number of cells in a range which had any number in them. I saw MANY attemps: VisualBasic, Regular expressions which required a huge overhead of code to load, dizzyingly complicated MOD and STR and LENGTH functions strung together in mind-bending combinations, and then... I found yours. Simple, elegant, and ultimately malleable to other purposes. I copied, pasted, modified, and BAM! I was done and it worked *perfectly*!
Dana
I am your biggest fan...I use your website on a regular basis and I find your Exceljet site amazing. I have never had a problem that you have not been able to resolve.
David
More Testimonials

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