Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Net Workdays | Excel Discussion (Misc queries) | |||
Calculating dates - complex scheduling problem | Excel Worksheet Functions | |||
Workdays | Excel Programming | |||
Stumper WORKDAYS Problem | Excel Discussion (Misc queries) | |||
Aircraft Scheduling Problem VBA code needs adjustment. | Excel Programming |