Hi all,
Within a report I receive it gives me a Billing period between 2 dates, sometimes these dates are at the end of one month and the beginning of another month. I must prepare a costing per month view. I have used logic in Excel to break up the “10/19/2014 - 11/1/2014 (Final Invoice)” string into a start and end date. With these dates I have identified how many days per month this range falls under, it could be all one month, it could be 2 months and I need to break up the Gross Ammount in its respective month based on the proportion.
Please check this file Attached: Sample Pro Rate.xlsx
shg can you check the fabulous formula you gave me, for some reason the formula breaks up the dates in the right spot but when you add the total amount it will be higher or lower than the total Gross Amount which it shouldn't be. I applied conditional formatting highlighting these cells in Yellow. Can you correct this problem? If you can you are wonderful
Bookmarks