Featured Formulas

Count cells equal to this or that

In this example, the goal is to count cells in the range D5:D15 that contain "red" or "blue". For convenience, the D5:D15 is named color. Counting cells equal to this OR that is more complicated than it first appears because there is no built-...Read more

Featured Functions

EOMONTH Function

The EOMONTH function returns the last day of the month, a given number of months in the past or future. You can use EOMONTH to calculate expiration dates, due dates, and other dates that must land on the last day of a month. EOMONTH returns a serial...Read more

Recent Articles

Dave this is amazing. I wish I got this message a year ago, so glad I signed up for your tips!! Thank you!
Mary
This is the best Excel site I have ever seen. The 500 formulas explain in detail each function needed and how they are constructed. Well thought out and immensely helpful to every Excel user.
Richard
I am 94 years old and have been working Excel for about 25 years; far from an expert. Still using Excel every day at a non-profit business. I wanted you to know that exceljet is by far the best reference to Excel that I have ever encountered. Thank you for a great job.
George

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