Hi All

I have found a formula on this forum that counts the number of days in each month between a given start and end date. However I need to modify it so that it gives me the number of working days and excludes UK bank holidays. The formula is below for information:

=MAX(0,MIN(EOMONTH(C$1,0),$B3)-MAX(C$1,$A3)+1)

Any help would be appreciated.

Thanks in advance.

Tony