Looking for a way to subtract holiday date from a date range
I'm trying to find a way to subtract a holiday date that occurs between two dates. Let's say you were given two random dates, then you needed to find the number of days between the dates minus any holidays.
For this example, the holiday occurs on the third monday in Februrary.
First I need to a way to check if the holiday exists within the date range, and then if the holiday does exist in the range, I'll need to subtract that date from the total day count.
I've tried using a calculated column to do this, but am having trouble using the out-of-box Spotfire functions to achieve this. I haven't been able to figure it out yet.
Does anyone know how this can be done?
Would appreciate the help.