Results 1 to 11 of 11

Distribute specific amount to months

Threaded View

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Distribute specific amount to months

    Hello everyone
    I have specific amount (200) and I need UDF function that enables me to distribute this amount according to the following
    For example:
    If start date is 25 / 3 / 2016 (March) & End date is 3 / 7 / 2016 ( July)

    So the number of days in March is 7 and the number of days in July is 3
    and other months [April - May - June] are full days

    Now I calculated the expected for the first month (March) with this formula
    =(C3/(B3-A3))*(EOMONTH(A3,0)-A3+1)
    and for the last month (July) with this formula
    =(C3/(B3-A3))*DAY(B3)
    As for the rest of full months : (200 - sum(the first month , the last month)) / the number of full months

    Can it be done using UDF function which refers to Start date & End Date & The amount (Cost)
    These are the three parameters

    Hope it is clear
    Thanks advanced for help
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How can I distribute a dollar amount into an odd number of rows?
    By cliff.clayman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2016, 09:36 PM
  2. Distribute revenue across months
    By Carolinanilorac in forum Excel General
    Replies: 3
    Last Post: 10-26-2015, 01:28 AM
  3. Distribute revenue across months
    By Carolinanilorac in forum Tips and Tutorials
    Replies: 1
    Last Post: 10-25-2015, 08:55 PM
  4. Distribute no of account and amount equally to callers
    By Apple Ling in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2014, 06:34 AM
  5. Distribute standard reserve amount in Respectively ?????
    By Skashusen in forum Excel General
    Replies: 1
    Last Post: 09-15-2013, 03:28 PM
  6. Need a formula to distribute an amount to specified fields
    By beth.randall in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2013, 09:40 AM
  7. [SOLVED] Using Lookup to distribute amount over a given duration
    By StarHunter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-16-2012, 06:20 AM

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