=(SUMPRODUCT(INT((MAX(end_date,start_date)-WEEKDAY(MAX(end_date,start_date)+
1-{1;2;3;4;5;6;7})-MIN(end_date,start_date)+8)/7))-SUMPRODUCT(ISNUMBER(MATCH
(WEEKDAY(holidays),{1;2;3;4;5;6;7},0))*(holidays= MIN(end_date,start_date))*
(holidays<=MAX(end_date,start_date))))*-(start_dateend_date)

start_date anmd end_date are two date cvells, holidays is a holiday list
range name
--

HTH

RP
(remove nothere from the email address if mailing direct)


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