I have an Approval Process Instance report which tells me the amount of time (Elapsed Days, Hours, Minutes, etc..) between when an approval instance was submitted and when it was completed.

Is it possible somehow to calculate this value but exclude Saturdays and Sundays?

As far as I can tell I am limited to using the Report Formula function. I don't believe I can add any custom fields to Approval Instance. And this report type does not support any fields from the actual object either.

If I need to do this in Excel that is also acceptable.

1 Answer 1


You could create a formula field that you can exclude the weekend days. The problem is that you're saying you cannot add any fields to the report type thus that idea is moot. I think you might be stuck with excel or if you can figure out how to add in fields to the report type, which feels strange that you can't, but if you can then there are examples out there.

Date Formula to Calculate date excluding weekends

Using formula to exclude weekend and holidays in salesforce

Excluding weekend and holidays from my days number


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .