Hi Chris, I have used your code and it works!!! such a great piece of work. However,I have some difficulties to apply it for my work. I need to calculate the working days between two days, which requires to exclude the weekends and holidays. First, different provinces have different holidays. Could you add one more parameter "province" in the format function? Second, if one of the holidays falls in the weekend, the consecutive weekday will not be the working day. How to exclude those weekdays? Thank you very much for your help