sheet summary

[tia.k]

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......

[royUK]

Try using a PivotTable, see

http://www.excel-it.com/pivot_tables.htm