Spotfire: Remove holidays from date range

I was able to add a calculated column to remove weekends for a date range but I would like to take out U.S. holidays if they are present. Below are some dates I'm working with. Can anyone help with this calculation?

dateAssigned shippedDate ShippingTime ship_NoBusinessDays [need]shipDays_NoBusinessNoHolidays
12/14/2018 1/11/2019 28 20  
10/24/2018 1/15/2019 83 59  
12/5/2018 1/18/2019 44 32  

 

TIA,

Rick

 

(1) Answer

Login