This is an insightful article, cannot wait to use the AGGREGATE function, especially where multiple variables are at play.

Always looking to find better formulaes to use on excel.
Had heard of EOmonth and Aggegrate formulae before and use them.  The others I hadn't, I can me perhaps using formulaetext formulae to help show others how figures have been calculated without having to enter the cell.

Interesting article EOMONTH will be useful.

Good to keep up to date with new functions in Excel.

This was a very useful article which I have bookmarked for future reference.

The N function is something I was not aware of, and will be able to use

I use SUBTOTAL regularly and will now switch to AGGREGATE

It's always worthwhile looking to see what Excel functions are available that you don't currently use, to see if there is a different and more efficient way of doing things.