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

Example:

20 days + 7/1/08 but don't count dates that I have entered in cells I2:I11

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

=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)

"Ryan" wrote in message
...
Example:

20 days + 7/1/08 but don't count dates that I have entered in cells I2:I11

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

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.

"Ryan" wrote:

Example:

20 days + 7/1/08 but don't count dates that I have entered in cells I2:I11