Excel count business days between two dates

datetime - Formula to count the number of holidays between 2 dates in excel - Stack Overflow

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.

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.

Calculating Business Days (Microsoft Excel)

You may also like. Recent from Gina Trapani 44 9. Redirecting to the Lifehacker store in.

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.