Featured Formulas

Date series

List nth weekdays of the month

In this example, the goal is to generate a list of "nth weekdays of the month" with a formula. For example, the formula should be able to create a list of any of the following:

  • 2nd Tuesdays of the month
  • 1st Fridays of the month
    • ...Read more
More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

REGEXEXTRACT Function

The REGEXEXTRACT function extracts text matching a specific regex pattern from a given text string. For the advanced Excel user, this function is a major upgrade. Instead of working out complex formulas based on functions like LEFT, RIGHT, FIND, MID, etc., REGEXEXTRACT can target...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Thank you for your help. I was trying to do something with Excel that I had never done before. Without your help it probably wouldn't have been done. Communication with you was pleasant and effective. The end result is great. Thanks again.
Mike
Of all the "Excel" sites I have visited, yours is the most friendly and inviting, that I have come across.
Steve
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
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