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?
|