+ Reply to Thread
Results 1 to 2 of 2

Calculate Pricing from Start and End Date with different Pricing Weight for Each month

  1. #1
    Registered User
    Join Date
    05-15-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Calculate Pricing from Start and End Date with different Pricing Weight for Each month

    I have a Data which include the Start Date and End Data and also the Total Price for the account during that period of time. I need a macros that calculate the New Pricing based on the weight given in the Monthly Price Tab. For example, if the start date is Jan 1st, from Jan 1st to April 30th, the price should be 0. It will only calculate the pricing starting from May to December and add them up as the New Pricing.

    Please note that some start date start in the middle of the month such as May 15th. I know that I can write a loop to calculate the numbers of days in each month that will be calculated in the New Pricing, but I'm not sure how to start this. I have attached the Data File.
    Last edited by xyang06; 06-05-2013 at 08:56 PM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Calculate Pricing from Start and End Date with different Pricing Weight for Each month

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    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 to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1