There are a couple of obscure functions in the analysis toolpak that will allow you to calculate how many workdays have elapsed. Enter a hire date and today’s date, and you can calculate the number of workdays. This function even allows for you to enter a range of company holidays which are factored into the calculation. Episode 399 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!