Calculate the Number of Working Days Between Two Dates [Excel Tip]

Calculate the Number of Working Days Between Two Dates [Excel Tip]

By laraib on from feeds.gawker.com

networkdays.png You already knew that Excel can do straight date math, but it can also take into account holidays to find the number of working days between two dates. Tech blogger Chandoo points out the =networkdays(start date, end date, list of holidays) formula, which turns out the number of days minus holidays (and vacation) between the start and end date—quite useful for work project spreadsheets. Chandoo offers several other "hey I didn't know that" Excel tricks too, like filtering unique items from a list, sorting data from left to right, freezing panes, and coloring your worksheet tabs. Excel can be Exciting: 15 Fun things to do with Microsoft Excel [Pointy Haired Dilbert - Chandoo.org]




  • 8
  • Bury
  • Vote

You must login to vote this story. Don't have an account yet? Join now, it's simple & free!

You must login to bury this story. Don't have an account yet? Join now, it's simple & free!

Login To Tagza

No account yet? Join us now, it's free!