LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Net Workdays Katie Excel Discussion (Misc queries) 4 September 19th 08 10:59 PM
Calculating dates - complex scheduling problem jct Excel Worksheet Functions 1 February 22nd 06 08:01 PM
Workdays Steph[_6_] Excel Programming 2 October 24th 05 08:22 PM
Stumper WORKDAYS Problem B.D. Excel Discussion (Misc queries) 6 February 19th 05 07:16 PM
Aircraft Scheduling Problem VBA code needs adjustment. aircraft_model VBA Excel Programming 7 November 28th 03 12:12 PM


All times are GMT +1. The time now is 10:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"