Formula for DATEDIFF on Workdays (Mon–Fri Only)

Request:
Add support for a DATEDIFF function that calculates differences in workdays only (Mon–Fri).

Details:
Currently, Gainsight’s DATEDIFF counts all calendar days, which skews reporting for operational metrics where weekends shouldn’t be included. Admins and ops teams often need to measure turnaround times that align to business days, such as:

• Closed Date → Provisioned Date

• SLA compliance on Support tickets

• Onboarding milestone timelines

Justification:
Accurate workday-based calculations are critical for SLA reporting and internal process measurement. Without this feature, admins must build complex workarounds (Salesforce formulas, external data processing, or custom objects), which reduces efficiency and increases the risk of inconsistencies across systems. Providing native support in Gainsight ensures consistent, reliable reporting aligned with how most businesses measure SLAs.

Technical Requirements:

• Extend the existing DATEDIFF function (or provide a new one) that excludes weekends.

• Suggested syntax example:

• DATEDIFF(Provisioned_Date, Closed_Date, "workdays")