I need to calculate WorkDays in each month between two dates.
WorkDays are defined as 8 hours per day.
Some of the pertinent fields are:
*note: DateStart and DateEnd should be inclusive in the calculation. ie. the date of DateStart counts as 1 day, the date of DateEnd also counts as 1 day. So, 1/1/17 through 1/15/17 = 15 days (instead of 15-1 = 14)
Results needed (for each month in the Assignment date range):
Month: Nov 2016
Note: 3 days @ 12 hrs/day = 4.5 days @ 8 hrs/day so that the 4 days worked in Nov at 12 hrs/day equal 6 days if the work day is calculated based on an 8 hr day