Date difference should also have an option to exclude weekends

Related products: None

I have often come across Customer Use cases where in they want to calculate fields like ‘Ticket Age’ or want to see only business days in date difference calculations. Is there any plan to have this functionality in near future?

To convert calendar days to business days you could divide by 7 and then multiply by 5. Would that work for your use case?


@dan_ahrens Yes, it did work with multiple transformations since decimal values had to be adjusted. Thank you!


Hello @dan_ahrens / all, I find myself with a similar problem, though the workaround provided here only seems to be somewhat accurate if there are a decent number of days in the period in question.

It does not work in my case because the period in question is often much less than 5 or 7 days. Do you know if Gainsight has anything in the works along the lines (or exactly like) Microsoft’s NETWORKDAYS function?