+ Reply to Thread
Results 1 to 2 of 2

Calculating the revenue by month between two different dates

  1. #1
    Registered User
    Join Date
    11-01-2013
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    6

    Calculating the revenue by month between two different dates

    Hi,

    I have to calculate the flat revenue split by month between 2 different dates.
    The two dates may be in the same year or different years.

    Can you please help me with an excel formula for the same.

    Is it possible to do the same in pivot?

    Appreciate your help in this regard.

    REgards
    Akila
    Last edited by AkilaAnnamalai; 01-08-2014 at 11:54 PM.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Calculating the revenue by month between two different dates

    Attached your workbook.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ 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. Recognizing Revenue month over mont for a multi month contract
    By schnack23 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-21-2013, 06:31 AM
  2. Calculate Projected Revenue (month-over-month)
    By karthih in forum Excel General
    Replies: 1
    Last Post: 09-05-2011, 08:51 AM
  3. Calculating Month and days betweens dates
    By deepak_gl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-30-2007, 08:34 AM
  4. [SOLVED] Calculating revenue per month by aggregating dates
    By Commutervet in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2006, 10:20 AM
  5. [SOLVED] Calculating Month To Date Revenue
    By Mike in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-31-2006, 12:00 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