I have a process start date column and a process end date column.
I also have dates in six columns - 1st Received Date, 1st Sent Date; 2nd Received Date, 2nd Sent Date; 3rd Received Date, 3rd Sent Date.
I am trying to calculate total days in process - BUT need to exclude the time between received and sent periods(including the actual received and sent dates). In addition, I need to exclude weekends.
For example: Process Start Date 1/1/2016 ; Process End Date 2/29/2016 - 60 Days including 1/1 and 2/29
1st Received Date 1/14/16
1st Sent Date 1/16/16
This would be a Monday, Tuesday, and Wed- would want to subtract 3 days from total process time
2nd Received Date 1/25/16
2nd Sent Date 1/29/16
This would be a Monday, Tuesday, Wed, Thurs, Fri - would want to subtract 5 days from total process time
3rd Received Date 2/15/16
3rd Sent Date 2/17/16
This would be a Monday, Tuesday and Wed - I would want to subtract 3 days from total process time
In addition, all weekends to be excluded.
60 Days - 18 weekend days - 3 days - 5 days - 3 days = 31 Days in Process
Thanks,
RV