![]() |
|
|
|
#1
|
|||
|
|||
|
Use NETWORKDAYS(start,end,[holidays])
[holidays] is an optional range of holidays to exclude. The equation returns the number of days between the dates inclusive of the dates so for your dates, the function returns 5 (without accounting for holidays). |
|
#2
|
|||
|
|||
|
Awesome, Thanks for the help!!!
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Changing Actual Finish dates changes original Finish dates
|
SomewhereinTX | Project | 3 | 12-20-2013 10:25 AM |
| showing calendar days by keeping normal workday calendar | ketanco | Project | 11 | 11-01-2013 08:27 AM |
Adding or subtracting in Word
|
danc | Word Tables | 1 | 10-29-2013 02:32 PM |
| If formula for subtracting dates | gbaker | Excel | 6 | 10-07-2012 07:06 AM |
Using WORKDAY with fractional day lengths
|
Scaffold | Excel | 11 | 06-29-2011 07:52 AM |