Employee days worked (-Holidays, -weekends, Snow Days, etc) Denise 12/27/2008 5:54:00 PM I am trying to save time counting the days newly-hired teachers will work in a 180-day work year. I have a spread sheet(school calendar) with all the possible dates in column C and a variable set for #snow days (we have only 1 so far) already setup. I want to be able to place a formula off to the side of the calendar and code it to reference the date cells after I type in an employee start in one cell and then calculate from that date entered to the end of the school year : # days worked, # days not worked(=the days leading up to their start day). Does this make sense??? It will save me a LOT of time counting and hopefully prevent counting errors. help

Re: Employee days worked (-Holidays, -weekends, Snow Days, etc) Pecoflyer <Pecoflyer.3l4kxm[ at ]thecodecage.com> 12/28/2008 10:59:43 AM Hi, have a look at 'Chip Pearson's NETWORKDAYS formula' (http://www.cpearson.com/excel/betternetworkdays.aspx) -- Pecoflyer Cheers - *_Membership_is_free_* & allows file upload ->faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=44498

Re: Employee days worked (-Holidays, -weekends, Snow Days, etc) Denise 12/31/2008 4:37:01 PM Thanks-I will try this when I get back to work after the holiday. I have never coded an array formula in Excel -so I will probably be back with more questions. "Pecoflyer" wrote: [Quoted Text] > > Hi, have a look at 'Chip Pearson's NETWORKDAYS formula' > (http://www.cpearson.com/excel/betternetworkdays.aspx) > > > -- > Pecoflyer > > Cheers - > *_Membership_is_free_* & allows file upload ->faster and better answers > ------------------------------------------------------------------------ > Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 > View this thread: http://www.thecodecage.com/forumz/showthread.php?t=44498 > >