Featured Formulas

Previous working day

In the worksheet shown, column B contains 12 dates. The goal is to calculate the previous working day before each date, taking into account weekends (Saturday and Sunday) and the holidays listed in column F. The formula should automatically skip weekends and any dates considered non-...Read more

Featured Functions

TRIM Function

The TRIM function strips extra spaces from text, leaving only a single space between words, and removing any leading or trailing space. For example:

=TRIM("   A stitch    in time.   ")  // returns "A stitch in time."

The TRIM function can...Read more

Recent Articles

I really appreciate your efforts, the site basically has everything we need, i've started recently working as a Quantity Surveyor, and Excel is very important in such kind of work.
Amina
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 am a self taught Excel user and love the simple, concise instruction videos. When I have downtime at work, I find myself eager to come to this site and see what new function I can learn and then try to figure out how to incorporate it into my work.
Toni

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