Forum Discussion
Solved
How to count number of days in roster depending today's date
I've a roster for staff (see attachment), cell C3 - AG3 is in date format(eg.1-Dec-2017), C6 - AG6 is the working day of the month, how to set a formula to count the numbers of working days(O) if tod...
Please see attached - it counts correctly 18 days if today is still 28th.
Hello,
Below could be another solution:
=NETWORKDAYS.INTL(C3,G3,1,{"25-Dec-2017","26-Dec-2017"})
But you need to explicitly specify the holidays in the 5th parameter of the formula.
For elegancy, You can even have these holidays listed out in a different range of cells and then define a dynamic range name or format such range as table and reference the dynamic range name or table name in the 5th parameter.
Thanks,
Bala..
Bala, as a comment
For elegancy it's better to pick-up array with holidays form row 6, they are already defined here. To keep the same data in several places (separate list of holidays) is the overhead in maintenance and potential source of errors.