Microsoft Office Tips, Tricks and Shortcuts

Whether it is meeting monthly, quarterly or annual targets, organising rosters, or counting down until Christmas, it is often useful to know the number of working days between two dates. The good news that you don’t need to sit with a calendar and count each day! Instead, you can use the Excel function NETWORKDAYS. NETWORKDAYS calculates the number of days excluding weekend days between a start date and end date. As an option, you can exclude any holidays in the period. The example we use in this article excludes the New Zealand public holidays in the number of working days....