Help me in time calculation

Originally Posted by xld

I am sure that you are right, but it is a self-help world - put the holidays in a named range called holidays. I ain't going to try and calculate all future possible holidays across the world in an Excel function, I'll be dead before it's finished.

Hmmm. not like you to shy from such a trivial challenge!