Using the forums and posts of others I am using this calculation to figure out the shipping days in a month. DATEDIFF('day',#7/01/2014#,#8/01/2014# )- MIN(DATEPART('weekday',#8/01/2014#),6 ) - MIN(DATEPART('weekday',#7/01/2014# ),6 )
My question is that I need to add weekends as half a business day. For example this month shipping days looks like this.
Shipping days Description
Base: 23.0 days in month less 1 holiday
Add: 0.5 days for the 5th and 6th
Add: 0.5 days for the 12th and 13th
Add: 0.5 days for the 19th and 20th
Add: 0.5 days for the 26th and 27th
Total shipping days
Is there a way to add to the calculation to make it total 24 shipping days for july?