Can someone help me choose the right function to count the number of days per month within a given set of dates?
A small sample file attached.
I can get the the total count of days between the two days, using this:
Total Days: ((((DateDiff("d",[StartDate],[EndDate]))+1)/7)*[DaysPerWeek]*[HoursPerDay])/8
but what I need is the total count of days for each month between the dates.
Optimally, I need to show something like this (summing the total days in each month for all Orders whose dates fall within those months):
Month Total Days