Results 1 to 3 of 3

Excel Function required to allocate Project Cost between two date range

Threaded View

  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1