Closed Thread
Results 1 to 2 of 2

Dividing the the total sales per month (Rental business)

  1. 06-23-2013, 03:59 AM #1
    miss_chloe
    miss_chloe is offline
    Registered User
    Join Date
    06-23-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    70

    Dividing the the total sales per month (Rental business)

    Attached is a report showing transaction item with a total at the last column. The report pertains to equipment rental. The computation of the Total is the regular monthly rate multiplied by the duration of rental. Base on the available data, especially on the start and end date, I want to know if there is a formula to divide the total into its respective month. Like for example, an item that has total of 20,000 is from April 15, 2013 to June 15, 2013, I should have something like this:

    April 2013 May 2013 June 2013
    5,000 10,000 5,000
    Reply With QuoteRegister To Reply
  2. 06-23-2013, 05:33 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Dividing the the total sales per month (Rental business)

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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