Microsoft Office Tips, Tricks and Shortcuts


Calculate the number of working days between two dates

October 12, 2012 Liz Todd

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....


Use range names to create meaningful Excel formulas

July 19, 2012 Liz Todd

Understanding what formulas actually show can be a challenge particularly if you are working with an Excel workbook that someone else has created. Formulas that use range names rather that cell references are much easier to understand. For example, =Income–Expenses is much more meaningful than =D9 D25. Creating range names is really easy! Simply select the cell or cells that you want to name, click the Name Box at the left of the Formula bar, type the name (eg Sales) and tap Enter. A few pointers: you’ll find the Name Box above column A; range names can’t include spaces or...