|
|
|
|
#1
03-25-2014, 05:39 AM
|
|||
|
|||
Subtracting dates workday function
I have been trying to subtract two dates from each other to get the number of days. The problem is I do not want to include Saturday and Sunday.
Example: 1/2/14 - 12/27/13 = 6 which includes the weekend. Need the result to be 4. How can I use the Workday function for this or is there some other function I should be using. Thanks GWB 
|
|
#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 32bit 
Office 2010 32bit
Hybrid Mode