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.

Count the Days between Two Dates in Excel

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: Video Skillet Two Cents Vitals Offspring Apps.

Calculate the Number of Working Days Between Two Dates. Excel Tip Excel Microsoft Excel spreadsheet Spreadsheets.

Edit Promote Share to Kinja Toggle Conversation tools Go to permalink. You may also like.

Recent from Gina Trapani 44 9. Redirecting to the Lifehacker store in.

How to count the number of days / workdays / weekends between two dates in Excel?

You are leaving a Gizmodo Media Group, LLC website and going to a third party site, which is subject to its own privacy policy and terms of use. Kinja is in read-only mode. We are working to restore service.