| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
