Call us on 01223 214177 or email us
Is this your last working week of the year or do you carry on until the bitter end? Whatever date you want to count down to (a holiday, anniversary, birthday, wedding, retirement, completion of house ... or Christmas) you can use Excel's NETWORKDAYS function to calculate the number of whole working days between two dates. It will exclude weekends and any dates you identify as holidays.
Here's how:
If you plan to take some time off in between the start and end date, stick these dates in a separate column and add them as a range to your formula. Have a look at Xmascountdown.xls to see a helpful example of how many days to work until Christmas assuming you take the week of the 22nd off. Speaking of which .. Most of you will probably take that week off, so I have decided this will be the last tip for 2014. Wishing you all a relaxing break!
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.