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

  • Thread starter Thread starter Ryan
  • Start date Start date
=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,
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Date Calculation question 3
how do I Count number of records beteen two dates- Excell 2007 2
Exclude Weekends 4
MISSING PARENTHESIS 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Alternative formula to exclude holiday calculation 6
Counting dates but excluding weekends 3

Back
Top