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

LAMBDA Function

The LAMBDA function provides a way to create a custom function in Excel. Once defined and named, a LAMBDA function can be used anywhere in a workbook. LAMBDA functions can be very simple or quite complex, stringing together many Excel functions into one formula. A custom LAMBDA function...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

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 so much for the amazing website that you run! It's always a happy day if I Google for something about Excel and find Exceljet in the results!
Jeremy
I really value they way your information is laid out and the samples and explanations - it is really user friendly!! It has helped me navigate many challenges and understand so much more about Excel. Excel has really complimented my efforts to support more efficiencies and leadership in the area I work (therapy team supporting students and teachers in schools).
Kevin
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