Exclude Holidays in Total

Hi AliGW,

Thanks for your response. The other post I have was about a different topic and I have just used the same sample workbook, I hope this is ok.

@bebo021999, I need AO3 and AP3 only.

AK3 will only be counted totally separate and does not require to be taken away from AO3 and AP3.

I feel like having a MATCH formula may work not to include the dates in AO3 and AP3 if filled but I don't know where to fit it in.

Appreciate all your help.

Thank you.