Featured Formulas

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
  • 3rd Mondays of the month
  • ...Read more

Featured Functions

Recent Articles

New Excel Functions

Nearly 50 new functions have been added to Excel! This is not your Dad's Excel anymore – a lot has changed. This article takes a quick tour of the new functions, with links to more detailed information....Read more

I do really appreciate the work you have done. It is a cut above everything else out there.
Doug
I just wanted to reach out and say thank you for the amazing article on comparing multiple columns of text and returning which value was found - its saved me absolutely hours and hours of manual searching. Knock out of the park brilliant!
Mark
I LOVE your site. It helps me frequently as I have no formal training but I'm very logic oriented and this site is put together so very well and has assisted me so very much! You've improved the quality of my life.
Mike

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