Scheduling by workdays only spreadsheet problem
 

I need to create a spreadsheet which calculates project mileposts.

Start date | Est. workdays | Est ready date Est ready
date allowing for weekends
A1 | B1 | A1+B1 |
A2 | B2 | C1+B2 |
C2 | B3 | C2+B3 |


where the current line's est. ready date (Col. C) becomes the next
line's start date (Col. A)

The NETWORKDAYS function in Excel 97 is not functioning as
described; I am getting anomalous results, even though I loaded the
Add-In for Excel 97. Forex, There's only one day between 10 May and 11
May, yet what I get is

A1=10 May | B1=1 | A1+B1=11 May | NETWORKDAYS
(A1,C1) = 2

Any suggestions as to what's going wrong?

Scheduling by workdays only spreadsheet problem
 

On Apr 16, 4:39 pm, "John Bartley K7AAY"
wrote:
Any suggestions as to what's going wrong?

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

Scheduling by workdays only spreadsheet problem
 

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.

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.