Scheduling by workdays only spreadsheet problem

  • Thread starter Thread starter John Bartley K7AAY
  • Start date Start date
J

John Bartley K7AAY

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?
 
Any suggestions as to what's going wrong?
Click to expand...

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
 
David said:
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
Click to expand...

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.
 
Solved it by using WORKDAYS in lieu of NETWORKDAYS.
Thank you all, in any case.
 
Back
Top