Featured Formulas

Dynamic array

Detailed LET function example

In this example, we have a simple set of data in B5:D16 that includes ID, Name, and Points. The goal is to generate a custom message for any name in the list by entering a valid ID in cell G5. The message uses the name from column C and the points in column D like this:

...Read more
More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

DATEDIF Function

The DATEDIF function is designed to calculate the difference between two date values in years, months, or days. The result from DATEDIF is a number that corresponds to the time unit requested. DATEDIF is a versatile function that can be used in financial analysis, project planning, age...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

First just wanted to say what a fantastic website and resource you have created. I only stumbled on it a few months ago but recommend it to anyone I come across with an interest in Excel (and who wouldn't love Excel!)
DH
THE MOST OUTSTANDING EXCEL EXPLANATIONS I HAVE ENCOUNTERED!!! The text used to explain the coding syntax is crystal clear; the actual code examples are crystal clear; the brief to-the-point explanations of what occurs when a function or a command executes -- crystal clear!!!
Michael
Your formulas and explanation are very helpful and convenient in my understanding. I used the "network.intl" function to find the working days of a month by exempting weekends and holidays. High appreciation and regards to you guys.
Muhammad
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