View Single Post
  #3   Report Post  
Jack
 
Posts: n/a
Default

there is no formula that will exclude holidays, the Days360 function will
calculate the number of days between 2 dates. Example:

=Days360("1/1/2005","1/15/2005") = 14

-Jack



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