View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John Bartley K7AAY John Bartley K7AAY is offline
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.