| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula - Excluding weekends & holidays
I have this very simple formula: =N42-K42 Both N42 and K42 are dates.
QUESTION #1 Is there a way to incorporate into this formula something that would exclude weekends when it calculates the number of days' difference? QUESTION #2 Is there also a way to incorporate into this formula something that would exclude statutory holidays when it calulcates the difference? I assume I would need to put a list of statutory holidays somewhere in the worksheet or on another worksheet. Thank you Connie Martin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| Skip the Holidays 2 | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| excluding cells from the formula when empty | Excel Worksheet Functions | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
Threaded Mode
