Generate Trading Days from Date range

[#1]

Hi all,

Please see attached excel file. in Data tab I have data like...

Branch, BranchopeningDate

In "I Want" tab the data  I want like displayed

Actually user should have option like in pic to choose date range

Once they select date then By month and Branch it should calculate Trading Days.

For Trading Day calculation below rule are apply

Monday	1
Tuesday	1
Wednesday	1
Thursday	1
Friday	1
Saturday	0.5
Sunday	0

also need to consider UK Bank holidays.

Please help!!!

Vinay

[Colin-Albert]

The NetWorkDays() function almost does this, but does not allow you to count 1/2 days.

[srchilukoori · Accepted solution]

Check the attached app.

[#4]

Brilliant Srchilukoori,

It working perfect.

Many Many Thanks.

Regards

Vinay