LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Scheduling by workdays only spreadsheet problem

Solved it by using WORKDAYS in lieu of NETWORKDAYS.
Thank you all, in any case.

John Bartley K7AAY wrote:
David G wrote:

NETWORKDAYS seems to count the workdays including the start and end
date.

For example, NETWORKDAYS(TODAY(),TODAY()) = 1.
So, NETWORKDAYS(TODAY(),TODAY() + 1) = 2, which is what you got.

Simply subtract 1 to get the result you expected to get. But make sure
the second date is greater than the first date before you do or else
the net workdays from today to yesterday will give you -2.

Cheers,
David G


Well, if there's a Sat or Sun involved, subtracting -1 does not work
well.

If I am counting Mon-Fri days only, that would work OK, but I am
trying to create a timeline generator which lets me plug in the start
date, the time for each task, and get the end date, and if two dates
span a weekend, the -1 screws up the calculation.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Net Workdays Katie Excel Discussion (Misc queries) 4 September 19th 08 10:59 PM
Calculating dates - complex scheduling problem jct Excel Worksheet Functions 1 February 22nd 06 08:01 PM
Workdays Steph[_6_] Excel Programming 2 October 24th 05 08:22 PM
Stumper WORKDAYS Problem B.D. Excel Discussion (Misc queries) 6 February 19th 05 07:16 PM
Aircraft Scheduling Problem VBA code needs adjustment. aircraft_model VBA Excel Programming 7 November 28th 03 12:12 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"