Calculation for a summary sheet

This is a discussion on Calculation for a summary sheet within the Spreadsheets forums in Other Technologies category; 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.........

Go Back   Database Forum > Other Technologies > Spreadsheets

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 03-26-2008, 08:44 AM
Default Calculation for a summary sheet

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......
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 04:54 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.