Results 1 to 1 of 1

Compute Project Start/End Date

Threaded View

COGICPENNY973 Compute Project Start/End Date 01-28-2011, 01:15 PM
  1. #1
    Registered User
    Join Date
    01-28-2011
    Location
    Morris Plains, NJ
    MS-Off Ver
    Excel 2003
    Posts
    1

    Compute Project Start/End Date

    I need help computing the Project Start Dates for each US state marketing campaign, under the Attached File "Strategic Plan" tab.

    Column E: Total Number of State Contacts
    Column F: Estimated Processing Time - calculated as =E2/(9*4.33) meaning, I could process 9 contacts per week in a given month, resulting in an answer in months.
    Column G: Project Begin Date: If I started my first state (Row 2), on February 1, 2011 (provided it's a weekday, because it will only be workdays), when would I complete the project (February 1, 2011 + results of Column F)
    Column H: Project End Date: What date will the project be completed if began on February 1, 2011 for Row 2 and so on?

    Column G and H are dependent upon each others similar to that in a Gannt's predecessor task, where Column G (Project Start Date) is at 02/01/2011, the processing time is "x.xx weeks", giving a task completion date of xx/xx/2011, which date also serves as Column G (Project Start Date) of Row 3, and the process continues until all the row data has been completed.

    Thanks,
    Penny
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1