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

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