Exclude weekends from the create date and closed date

Summary

Need to exclude the weekends while calculating he date difference

Content

Hi Team,

I am struggling to calculate the time difference between incident creation and closed dates by excluding the weekends. here are the columns and function which I am using to calculate date difference date_diff(incidents.closed,incidents.created), but this logic is counting the days including the weekends. As per requirement I need to exclude the weekends and calculate actual business dates. Could you please help me here on this issue.

Thanks & Regards,

Ashok Ganesh

Version

18C