On Wed, 2 Mar 2005 17:50:55 -0500, "CLR" wrote:
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
That will only work if the list of holidays only includes holidays between the
dates in A1 and B1
--ron
|