+ Reply to Thread
Results 1 to 3 of 3

Monthly run rate calculations with FROM and TO dates

  1. #1
    Registered User
    Join Date
    03-16-2016
    Location
    Berlin
    MS-Off Ver
    MS Office 2013
    Posts
    28

    Post Monthly run rate calculations with FROM and TO dates

    Hi dear excel community,

    I hope you are having a great day so far.
    I am reaching out in hope you could help me with something that's probably rather easy for you.

    It's about run-rates and calendarization.

    For example, (starting of easy)
    if I have a contract that starts 01/01/2019 until 31/12/2019 with an amount of 12,000, I would like to see each month Jan - Dec with an amount of 1,000.

    Obviously now it can be more difficult, since some contracts start in the middle of the year and maybe end in the middle of the year.

    I attached you an excel on how it would look in a perfect world.

    I am not using this forum too often, I hope I asked my questions clearly and confirming to all the forum rules
    Thanks so much in advance and if you have any questions, please let me know.


    Best,
    AFGP
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Monthly run rate calculations with FROM and TO dates

    Try this in I5:

    =IF(AND($C5<=EOMONTH(I$3,0),$D5>=I$3),$E5/$F5,"")

  3. #3
    Registered User
    Join Date
    03-16-2016
    Location
    Berlin
    MS-Off Ver
    MS Office 2013
    Posts
    28

    Re: Monthly run rate calculations with FROM and TO dates

    WOW! It really was that simple?

    For now it seems to work perfectly. I'll do some more checks and mark it at solved in case everything runs smoothly.

    WOW, thanks so much already, Phuocam!
    This forum is just soooooo good.


+ 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. Compound growth rate (Getting monthly rate from annual growth rate)
    By rsbrais in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2017, 04:35 PM
  2. Monthly growth rate
    By thomased in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-16-2016, 08:25 PM
  3. Replies: 1
    Last Post: 03-08-2013, 04:18 PM
  4. Replies: 5
    Last Post: 03-07-2013, 11:38 AM
  5. daily rate monthly sums
    By oregonlahar in forum Excel General
    Replies: 1
    Last Post: 04-09-2010, 04:06 PM
  6. Calculations (pro-rate)
    By KLahvic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2009, 10:05 AM
  7. [SOLVED] monthly growth rate
    By my in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-01-2006, 09:10 PM

Tags for this Thread

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