Featured Formulas

Sum and ignore errors

In this example, the goal is to create a formula that will sum values in a range that may contain errors. A common problem in Excel is that errors in data show up in the results of other formulas. For example, in the worksheet shown, the SUM function is used to sum the ...Read more

Featured Functions

WORKDAY Function

The WORKDAY function calculates a date that is a given number of working days from a specified start date, automatically excluding weekends and, optionally, holidays. You can use the WORKDAY function to calculate project start dates, delivery dates, due dates, and other dates that must...Read more

Recent Articles

Just wanted to send you a thank you note for your website. It is very well presented, and has nice features and very good examples. I particularly like the one I found this week for "Get work hours between dates and times". It was perfect to calculate the time a business passenger flew "during their personal time", i.e. a passenger took the 6am flight, while his normal workday starts at 8am. Very clever formula. I have been a regular user of your website over the years.
I frequently use the resources you provide here on your website, and wanted to thank you for the awesome work you are doing. It is very well done, has great breadth, and lays out complex topics in an understandable way.
Chase
I have been referencing your website for many years and just wanted to say thank you for what you do. The presentation of content, clarity in explanation, and library of helpful tips is better than anything else I have found like it on the internet. Great work.
Tyler

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