Thread: Another SUMIF
View Single Post
 
Old 06-05-2016, 09:54 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 Jeffrey
Sorry, my calculations were not completely correct. Please see revised sample workbook.
Basically I need to calculate the number of working days for each month for each Skillset between the Start and End dates for each activity on sheet 1.
Hope this helps.
Kind regards
Tony
Attached Files
File Type: xlsm Sample Resource Pool Availability Template.xlsm (82.0 KB, 15 views)
Reply With Quote