+ Reply to Thread
Results 1 to 3 of 3

Excel Function required to allocate Project Cost between two date range

  1. 12-09-2013, 08:36 PM #1
    Mysore
    Mysore is offline
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Post Excel Function required to allocate Project Cost between two date range

    Hi Friends,

    Attached is a spreadsheet wherein I'm trying to extrapolate project costs
    across various months based on working days in a month subject to start and end
    dates of the project. Need an accurate formula to spread the cost.

    Any help is much appreciated.


    Thanks

    Kris
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-09-2013, 09:54 PM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Excel Function required to allocate Project Cost between two date range

    Using your posted workbook...
    This regular formula, copied across to the right, returns the number of workdays of the project that are in a given month
    Please Login or Register  to view this content.
    or, this regular formula, copied across to the right, returns the cost allocation for those months
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
  3. 12-09-2013, 11:02 PM #3
    Mysore
    Mysore is offline
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Re: Excel Function required to allocate Project Cost between two date range

    Thanks Ron. That helps heaps.

    Cheers

    Kris
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Project Visual Reports to Excel to distribute cost over time - Cashflow
    By annaanderson in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-26-2013, 05:28 AM
  2. [SOLVED] Outputing engineering cost based on total cost of project. Looking for help with matching
    By cadamhill in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-17-2012, 09:31 PM
  3. Object Required Error in VB Excel Program that Passes Range to a function
    By navs8603 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-06-2011, 05:10 AM
  4. Cost Driver Analysis - Need formula to allocate manpower cost
    By Swastik Banerje in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2009, 11:16 AM
  5. Macro to allocate amt to different period, based on date range
    By raj8000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2009, 08:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1