How to find the number of working days in Excel spreadsheet

Welcome to your weekly Excel 3 tip Friday post, it’s just a short dose of Excel goodness before you start the weekend. Each week we’ll cover a tip, a shortcut and a function - making it super easy for you to get better at Excel.

If you find this useful or have requests or ideas for future editions, send me a message or comment at the bottom of this post! Now, on with the tips. 

A quick win you can learn today -

Here's a useful time saving tip: If you have several cells on a sheet that you need to apply the same formatting to, you can select them all together by holding the Ctrl key while you click on each cell. You can also drag the mouse to select multiple ranges rather than just individual cells.

A keyboard shortcut I'm adding to my list - 

Do you ever find you receive dates in an inconsistent format? Using the formatting menu can be slow and tedious at times, but you can use the Ctrl + # shortcut to apply the custom date format dd-mmm-yy to any date!

 

A function I've found super useful this week - 

When producing dashboards, I'm often tasked with finding the number of working days between two dates. This can be done using the NETWORKDAYS function - which works out the number of days between two dates in whole days, excluding weekends. You can also include a list of dates in the final part of the function to exclude things like bank holidays or non working days. The function just has 3 elements - the start date, end date, and optionally a range containing other dates to exclude.

 

Hope these were useful, until next time all the best. 

- Martyn

Edinburgh, Scotland

April 2018

p.s. Our new Excel course is now live at www.dataminded.co.uk

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit