View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

Assuming your dates are in A1 and B1,
Create a RangeName called Holidays in an out of the way place and list your
holidays there........then use

=(B1-A1)-COUNT(Holidays)

Vaya con Dios,
Chuck, CABGx3



"abs2299" wrote in message
...
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.