Having formula errors on a spreadsheet can be bad news. They look ugly, they frighten the less Excel experienced among us and they stop our other formulas from working.

If you have formula errors on a spreadsheet it is normally best to stop it at its source. To either correct the error, or to hide it using formulas such as ISERROR and IFERROR.

However, if your spreadsheet is large, having these IFERROR functions in every cell to protect against error values will add more calculation time to your spreadsheet.

There is a function in Excel called AGGREGATE which allows us to perform various functions on a range whilst ignoring formula errors.

In this blog post, we explore five of the best date functions in Excel. There are many awesome date functions, so it is difficult to choose only five.

This includes date functions to calculate the number of working days between two dates, and automatically finding the date in exactly two months time.

Let’s dive into these awesome date functions in Excel..

Written by Mynda Treacy of My Online Training Hub.

Writing formulas can have you tearing your hair out, especially when you start nesting them. Here are 4 tips to help you troubleshoot formulas when things go wrong.