Featured Formulas

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

Featured Functions

NETWORKDAYS Function

The NETWORKDAYS function returns the number of working days between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays provided as a list of dates. NETWORKDAYS can be used to calculate employee benefits that accrue...Read more

Recent Articles

YOU ARE COMPLETELY BRILLIANT. I find myself coming back to your site by default, again and again. I've now bookmarked it and shall shortly write an IFERROR macro to bring me here automatically!
Ian
Exceljet is my go-to place when I need a formula that I can't remember how to code. You folks have a terrific website, you examples are easy to follow, you explain what the formula is doing, and show options or alternatives. I usually use your alternatives to teach myself new ways to exploit Excel. Great job and thank you.
Steve
My Lord where have you been all my life?...I've learned more awesome tricks/functions in one afternoon from you than in the last 10 years.
Robert

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