1 Reply Latest reply on May 12, 2014 11:49 AM by Joshua Milligan

    How to calculate if a customer has been contacted within the first 48hrs, but exclude weekend days and US holidays.

    Lauren Hettler

      I have a table that has two date fields:  "date_of_first_contact" and "date_incident_closed".  The format of the fields is "MM/DD/YYYY" and I am not worrying about time, just days.  How do I figure out if the customer was contacted within 48hrs, but exclude Saturday, Sunday, and US holidays?  Does Tableau have a holiday calculation or do I need to create a table?