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.
Bookmarks