Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am setting up a combination project management and financial spreadsheet
for a builder. I want to calculate the ending date from the duration days. If I put in Monday, 6/12/06 and add three days, the result is Thursday, 6/15/06. this is as if it is adding 3 days from the end of Monday vs 8am Monday. (Not the way the builder thinks.) Is there a setting I'm missing that will return the date Wednesday, 6/14? Also, the builder is still on MSOffice 2002 so NETWORKDAYS function is not available to him. Naturally, he wants no beginning or end dates to fall on weekends. Anyone have a formula to accomodate that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
count between start date and end date | Excel Discussion (Misc queries) | |||
Project Management Schedule | Excel Worksheet Functions | |||
How to project the due date according to a number of working hours | Excel Discussion (Misc queries) | |||
How to project the due date according to a number of working hours | Excel Worksheet Functions |