Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2014, 05:39 AM
gbaker gbaker is offline Subtracting dates workday function Windows 7 32bit Subtracting dates workday function Office 2010 32bit
Competent Performer
Subtracting dates workday function
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-25-2014, 07:34 AM
gebobs gebobs is offline Subtracting dates workday function Windows 7 64bit Subtracting dates workday function Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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).
Reply With Quote
  #3  
Old 03-25-2014, 11:43 AM
gbaker gbaker is offline Subtracting dates workday function Windows 7 32bit Subtracting dates workday function Office 2010 32bit
Competent Performer
Subtracting dates workday function
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Subtracting dates workday function

Awesome, Thanks for the help!!!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtracting dates workday function 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
Subtracting dates workday function 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
Subtracting dates workday function Using WORKDAY with fractional day lengths Scaffold Excel 11 06-29-2011 07:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft