Using COUNTIF & COUNTIFS with Dates

This tutorial was prompted by a question on one of the LinkedIn groups I’m a member of. An IT Technician has a spreadsheet that displays a list of tickets submitted to the HelpDesk. Each ticket has a status (for example Resolved, Pending, etc) and a date. The...

How Many Sleeps Until Christmas?

Last week during one of my Excel courses, I was talking about dates, Someone asked if Excel could calculate “how many sleeps until Christmas”. In response to this, I’ve created a “how many sleeps until Christmas” calculator. There’s...