Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2016, 03:42 AM
OTPM OTPM is offline Help With a Formula Windows 7 32bit Help With a Formula Office 2010 32bit
Expert
Help With a Formula
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with dragging a formula and changing a reference column as I drag the formula. LupeB Excel 1 10-22-2015 03:02 PM
help with a formula srockwell25 Excel 4 08-22-2014 02:47 AM
Help With a Formula Formula Excel Excel 1 08-14-2014 05:11 PM
Formula Help clo312 Excel 11 01-11-2014 02:54 AM
Formula Help OTPM Excel 5 02-21-2013 08:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:07 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft