+ Reply to Thread
Results 1 to 4 of 4

Calculate finish date

  1. #1
    Registered User
    Join Date
    12-22-2014
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    79

    Calculate finish date

    Hi friends,

    I want to calculate the finish date for production.
    I am assuming 2 days no production per month. Weekends dont matter.
    I have a start date and the number of days it will take to complete the task.
    The only thing I need to take into account is the number of days in a month (30 days, 31 days, 28/29 days) to calculate the finish date.

    Could anyone please help with a formula?
    Attached some data
    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,646

    Re: Calculate finish date

    Try this in F2:

    =E2+ROUNDUP(C2,0)+D2*C2/30

    "2 days per month" is not very precise, because of the varying number of days in a month, so I've assumed 30 days in the formula.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    12-22-2014
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    79

    Re: Calculate finish date

    Thanks for your response Pete.

    The result is as expected.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,646

    Re: Calculate finish date

    Well, that's good to hear.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

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