View Single Post
  #1   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

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?