View Single Post
  #4   Report Post  
tjtjjtjt
 
Posts: n/a
Default

If you install the Analysis Toolpak from Tools | Addins, you can use
=Networkdays(start_date,end_date,holiday_list)

tj

"abs2299" wrote:

I am wondering if there is a formula out there that will calculate the number
of days between two dates, but exlclude holidays. I know there is a formula
that will calculate work days, but I need one to calculate all days of the
week, not just work days.