Employee days worked (-Holidays, -weekends, Snow Days, etc)

[Denise]

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

 

[Pecoflyer]

Hi, have a look at 'Chip Pearson's NETWORKDAYS formula'
(http://www.cpearson.com/excel/betternetworkdays.aspx)

 

[Denise]

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.