+ 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
    89

    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
    Office 2019 (still learning)
    Posts
    24,604

    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
    89

    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
    Office 2019 (still learning)
    Posts
    24,604

    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)

Similar Threads

  1. Replies: 7
    Last Post: 06-12-2018, 11:42 AM
  2. Replies: 6
    Last Post: 10-04-2016, 05:01 PM
  3. calculate time to finish
    By Entropie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-23-2016, 11:25 AM
  4. Calculate start date from finish date minus 14 working hours
    By PietBom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2014, 07:23 PM
  5. [SOLVED] How do i calculate work hours from only a start and finish date and time?
    By transitsolutions in forum Excel General
    Replies: 1
    Last Post: 02-28-2013, 03:39 PM
  6. Calculate doesn't finish
    By pertile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2012, 11:19 AM
  7. [SOLVED] [SOLVED] How to Calculate a Projected Finish Date based on Work Week and Holidays
    By mojado44 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2005, 09:10 PM

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