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

What are C1 B3 and A3 please?
Perhaps post a small sheet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer

Here is my sample Worksheet layout.

Start
EndJan 16Feb 16Mar 1602/01/1602/01/1610016/01/1627/03/1616282703/02/1611/03/1602611

Thanks
Tony

Hi Pecoflyer

Here is my sample Worksheet layout.

Start End Jan 16 Feb 16 Mar 16
2/1/16 2/1/16 1 0 0
16/1/16 27/3/16 16 28 27
3/2/16 11/3/16 0 26 12

This is a manual sample of the results including weekends and bank holidays. I want to exclude weekends and bank holidays.

See sample workbook attached.

Thanks

Tony

Attached Files

Capacity Tool Sample.xltx (11.3 KB, 11 views)