I made an excel sheet to calculate the number of the vacation taken
by
the employees
excluding the weekend and the official holidays.
B22=From (date)



C22= To Date
D22= Total Taken
C44:C53 =Official Holidays
=NETWORKDAYS(B22,C22,C44:C53)


what i do really need is to find formula that allows me to know the
number of days taken in each month of the year
as a summary sheet
A5=NAME
C5=JANUARY
D5=FEBRUARY
etc......