+ Reply to Thread
Results 1 to 2 of 2

spreading a project value over a number of months based on order month & project duration

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    UK
    MS-Off Ver
    Excel 2012
    Posts
    1

    Question spreading a project value over a number of months based on order month & project duration

    Hi All.

    I am trying to build a formula that will evenly spread an project order value over a number of months based on the project duration and win date

    Duration could be 1 - 60 months
    Revenue starts in month following order month
    values are inserted automatically.
    default is zero

    section of spread sheet attached - values have been entered manually at this stage
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: spreading a project value over a number of months based on order month & project durat

    See attachment..........
    Attached Files Attached Files
    Kind regards,
    Piet Bom

+ 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. [SOLVED] Need formula to calucalte based on start month # and duration # of months
    By NS4Excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2014, 05:59 PM
  2. [SOLVED] Sum values in cells based off of project name and project end date
    By ronalgreen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2013, 01:08 AM
  3. [SOLVED] Function that concatenates multiple sub-project descriptions based on project code
    By markbpi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 06:49 PM
  4. Linking a project name to a project number
    By tvg543 in forum Excel General
    Replies: 2
    Last Post: 11-08-2012, 04:39 PM
  5. Spreading Hours based on Project Phases and Start/End Date
    By ChelseaT20 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2012, 04:38 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