Episode 399 – Workday Calculations


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(…)

Episode 357 – Date Differences


You have two dates in Excel and want to find the elapsed years and months. The solution is to use an ancient function from the days of Lotus 1-2-3. Episode 357 shows you how to use the function, as well as a cool formatting trick to show years and months in the same cell. This(…)

Learn Excel from MrExcel