5 Replies Latest reply on Feb 14, 2012 2:02 PM by philmodjunk

# Counting the number of business days to process a report

### Title

Counting the number of business days to process a report

### Post

Hi all,

I have read some good posts and tried the calculations, but cannot seem to get them to work.  I have a DateReceived, DateDelivered and DaysToProcess.  I'm trying to calculate the DaysToProcess but excluding Saturdays and Sundays.  So, if you got a report on Friday and closed it on Monday, it would be calculated the same as if you got the report on Thursday and closed it on Friday.  Both calculations would produce "1" day.

Thanks, Emmett

• ###### 1. Re: Counting the number of business days to process a report

I can guess, but let's be sure. What calculations did you try?

Also, are holiday closures a concern?

• ###### 2. Re: Counting the number of business days to process a report

Ummm.  Nevermind.  As usual, I didn't slow down and read the calculation closely enough.  I got the following to work:

Int((EndDate - StartDate)/7) * 5 + If(DayofWeek(EndDate) < DayofWeek(StartDate),
Min(5, DayofWeek(EndDate) - 1) + Max(0, 6-DayofWeek(StartDate)),
If(DayofWeek(StartDate) < 7, Min(6,DayofWeek(EndDate)) -
DayofWeek(StartDate), 0))

Have a great evening.