| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filtering a list to exclude 2 different dates | Excel Worksheet Functions | |||
| Exclude Cell from Calculation | Excel Discussion (Misc queries) | |||
| How do I set up a calculation to exclude weekends? | Excel Worksheet Functions | |||
| Date Calculation to exclude weekends | Excel Worksheet Functions | |||
| calculation to exclude weekends | Excel Worksheet Functions | |||
Hybrid Mode
