Microsoft Excel handles temporal data effectively if you know which formulas to use. The problem is that Excel includes over 20 date and time functions, but most people only ever need a small core set ...

Mastering Excel's Date & Time functions can significantly improve productivity and data analysis. In my latest report, I explore essential Excel functions including DATE, TIME, YEAR, HOUR, MINUTE, ...

Dates are more powerful than most people realise — and more confusing too. Here is everything you need to work with them confidently. Here is a question I get asked more than almost any other. "Why is ...