Calculating The Time I Wasted Here Is So Much Easier Now

This falls squarely into the category of things I missed the boat on, but excel already had an easy built in CAGR function via Rate. e.g. =Rate(periods,,-first,last)

Which is not to say I was re-writing the formula every time - because I had already falsely optimized with a macro that needed adjusting, before building a macro that didn’t need adjusting….but didn’t always work.

(╯°□°)╯︵ ┻━┻

#excel #things I missed the boat on