|
|
#2
03-25-2014, 07:34 AM
|
|||
|
|||
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). 
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode