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