Thread: Help With a Formula
View Single Post
 
Old 05-26-2016, 03:42 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi Pecoflyer

Here is my sample Worksheet layout.

Start End Jan 16 Feb 16 Mar 16
2/1/16 2/1/16 1 0 0
16/1/16 27/3/16 16 28 27
3/2/16 11/3/16 0 26 12

This is a manual sample of the results including weekends and bank holidays. I want to exclude weekends and bank holidays.

See sample workbook attached.

Thanks

Tony
Attached Files
File Type: xltx Capacity Tool Sample.xltx (11.3 KB, 11 views)
Reply With Quote