Forum Discussion
IF / Countif / Sumif - Formula help please
I can't get this if function to do what I want. What am I doing wrong? Column C. I'm trying to get the column to add one for every row through the number at the top of the sheet (20, 26 etc) ...
Have you looked at the NETWORKDAYS or NETWORKDAYS.INTL functions?
Hi Steve,
That could be, but the problem with NETWORKDAYS.INTL it's not possible to mark weekend as workday. For example, if we have regular weekends on Saturday only and government decides one time in the year we work on Sat but be off on Sun instead - we may add such Sun to holidays list, but we can't say to function what this concrete Sat is not weekend.
But perhaps that's not Chris' case, he considers fixed not more than 5 working days cycle.
