Reply to thread

Message: [QUOTE="tony.lipschitz, post: 3716578"] As a Human Resources Manager, I need to calculate how many working days leave each employee takes. As some staff work a 5-day week I have used the formula, =NETWORKDAYS(A1,B1,O1:O15) where A1 is the first day of leave and B1 is the last day of leave. O1 to O15 list public holidays which the formula then deducts. However I want to add a column for staff who work a six-day week with a formula which will count the number of Saturdays in this same period ( adding the two results will give me how many working days 6-day-a- week employees take) Can any one please help? [/QUOTE]