How do I Exclude a list of dates in a date calculation?

B

Bob Phillips

=A1+SUMPRODUCT(--(ISNA(MATCH(ROW(INDIRECT(A1&":"&A1+20)),I2:I11,0))))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
R

Ron

Ryan,
You might want to take a look at the WORKDAY and NETWORKDAYS functions.
They allow for list of "Holidays" to be excluded from calculations. The
problem with these 2 functions is that they assume that Saturday and Sunday
are NOT workdays for anyone, ever.
 
Top