Skip to main content
Gainsight Employee ⭐️
Anshita
Gainsight Employee ⭐️
October 8, 2020
New Idea

Date difference should also have an option to exclude weekends

  • October 8, 2020
  • 3 replies
  • 100 views

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?

    3 replies

    dan_ahrens
    dan_ahrens
    Expert ⭐️⭐️⭐️
    October 9, 2020

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

    VP of Customer Success at Forcepoint
      Gainsight Employee ⭐️
      AnshitaAuthor
      Gainsight Employee ⭐️
      October 13, 2020

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

        marshallthomson
        marshallthomson
        Contributor ⭐️
        January 4, 2023

        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?

         

        Terms & ConditionsAccessibility statement