Need to work out the working days (Mon-Fri), excluding bank holidays, between the start and end dates in columns A + B, by month in columns E-P.
This all works fine with the current formula.
Change required:
-Need to deduct 0.5 where there is an x in either the afternoon or morning columns (Denoting half a day, instead of a full day). This can be applied to the first month where the days are split between more than 1 month. E.g. row 5 would be 0.5 days in Mar and 1 day in Apr, instead of 1 day in Mar and 1 day in Apr.
Can do it with a few ifs but thought there maybe a nice short and fancy way
Bookmarks