Re: Networkdays Function
Thanks for your comments. The value of n refers to the range D2:AH2, where the value exceeds the days in the current month the target cell/s will be blank so will not increment the count. The problem of having 4 or 5 Sats in a month I had hoped to circumvent by including non-working saturdays in the list of Holidays. Unfortunately, the 28 day cycle idea is not feasible in the current requirement, worse, I now learn that working saturdays are a matter of negotiation on the day before, and, even then, honoured more in the breach than the observance.
So, I have come to the conclusion that I cannot cater for all these variables and so will have to accept that there is a certain amount of post-event adjustment.
I would still like to know what it is about the code I tried to use, particularly the COUNTIF statement.
thanks again for all your input and interest