Featured Formulas

Date and Time

Get nth day of week in month

This example demonstrates how to calculate the nth occurrence of a specific day of the week within a month. For instance, you might need to find the 2nd Tuesday, the 4th Wednesday, or the 1st Friday of any given month. The worksheet is structured with the starting date in column B, the...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Logical

IFERROR Function

The IFERROR function returns a custom result when a formula returns an error and a normal result when a formula calculates without an error. The typical syntax for the IFERROR function looks like this:

=IFERROR(formula,custom)...Read more
More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I have to say that I knew practically nothing about Excel when I started using VBA about 6 years ago. However, your newsletter (weekly), which I started using about four years ago has really allowed me to appreciate Excel - I don't use VBA because of the learning from your site/weekly email. Thank you for being such an amazing teacher.
Adrian
In the realm of Excel, I feel it is important to understand how & why specific formulas and functions work in particular situations, as well as how to build them. Never have I seen an organization systematically break down Excel’s built-in functions and comprehensively explain how each component ticks. You guys are incredible!
William
Sir your website is awesome. It gave me what I want. Thanks and hope it will help me again when I need it.
Atul
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