I'm having trouble calculating the start and finish dates (columns H and I) on the attached spreadsheet. I appreciate any help in the calculation of these two columns. Thanks.
I'm having trouble calculating the start and finish dates (columns H and I) on the attached spreadsheet. I appreciate any help in the calculation of these two columns. Thanks.
looking at some o your range names, they have #Reff errors in them. this is causing #ref errors in col I, whic looks like it feeds into H
Take a look at ranges HH and Strt and see if you can fix the #Ref erros inthem and see if that fixes your problem?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Honestly, I worked on this spreadsheet with another person over a year ago, and completely forgot everything, and could not even begin to fix any errors. What I'm looking to do is:
1. Taking the assumption of the amount of time in Process Hours (Column G) and assuming I work an 8 hour day
2. Making the assumption I begin the project on July 1, 2012 and must complete the first State (California, Row 3), when would I finish?
3. This finish date +1 (the next business day) I would be able to start the next state (New York, Row 4), until I finish the entire project.
Thank you.
ok, this may take a few back and forth, but lets see how this works for you. test it and let me know if we are getting close
The finish dates in your attachment are moving backwards in time instead of forwards... meaning, if I started project 1 for California on July 1, 2012 and it takes me 149+ process hours to complete, the finish date cannot be in June, 2012 (the month before) because we're moving forward from July 1st start date.
sorry, stupid mistake on my part.
the formulas in I should be...
=WORKDAY(H3,G3-(Start-End),Table1[Holidays])
i had them as...
=WORKDAY(H3,G3/(Start-End),Table1[Holidays])
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks