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]






11 Comments  
Add this link to...  Tell a friend  Bury

Preview



Comments Who Voted Related Links


 
Site Links
RSS Feeds
Register
All About Tagza
About Tagza
Report a Website Bug
Contact
Top Stories
Today
Yesterday
Weekly
Monthly | Yearly