+ Reply to Thread
Results 1 to 2 of 2

Updating phasing profile

  1. #1
    Forum Contributor
    Join Date
    09-15-2012
    Location
    las vegas
    MS-Off Ver
    excel 2007
    Posts
    147

    Updating phasing profile

    I've got a project start date and end date and the phasing of the project. Everything is in fiscal year, that is, the year ends in 09/30 not 12/30. The project will always be 78 months.

    Now, I also have a second project start and end date (starting on line 7). The phasing above it is the original phasing. What I'm trying to do is to find a function that will adjust the phasing when the project start and end dates change.

    Thanks guys.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,643

    Re: Updating phasing profile

    I feel that we would need to know how the percentages in cells D4:J5 were calculated in order to be able to adjust those calculations to use in cells D7:J8.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Value phasing formula based on several conditions
    By AlisaS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2019, 02:54 AM
  2. [SOLVED] Value phasing formula based on several conditions
    By AlisaS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2019, 05:06 AM
  3. [SOLVED] Value phasing formula
    By AlisaS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2019, 12:05 PM
  4. [SOLVED] Postive Phasing Integers
    By Excel-Access in forum Excel General
    Replies: 3
    Last Post: 04-12-2019, 12:50 PM
  5. Urgent help with formula: incremental phasing
    By targus92 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-23-2017, 04:41 AM
  6. Phasing project development cost
    By OmarHamza in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2016, 10:06 AM
  7. budget revenue phasing
    By fedzy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-13-2012, 05:59 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