Does the formula in sheet Activity, column E return what you expect?
Could you please try to fill in manually some expected values in column F and G.
Can it happen that more holidays appear in a single row on sheet Activity (column a:d)
If YES, what should be returned?
|