Shopping Podder - the Best of Computer Postings! :: View topic


www.ShoppingPodder.com Leading Computer Shopping, News and information	Part of the Identityscape.com network... getxfactor.com jmoodmusic.com smartbusinesschoices.com mintdepot.com lowfaresalways.com evangelicalview.com shoppingpodder.com soproudlywehail.com webnews.ws currenthumor.com

Calculation for a summary sheet

Shopping Podder - the Best of Computer Postings! Forum Index -> Computer Applications - Spreadsheets

View previous topic :: View next topic

Author

Message

Tia
Guest

Posted: Wed Mar 26, 2008 11:44 am Post subject: 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)

Quote:

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

Display posts from previous:

Shopping Podder - the Best of Computer Postings! Forum Index -> Computer Applications - Spreadsheets
Page 1 of 1

All times are GMT

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum