Bonus $15 Paypal deposit for solution and bragging rights
Hi Pros,
First post
I have a spreadsheet I inherited that already has a formula in it. Problem is it only does part of the job needed. The examples in the attached is contract coverage for 1 year and broken down in monthly columns to recognize cost. But, I need the monthly breakdowns to take into consideration partial months for the 1st and last month. The first four lines is how he formula currently works and shows it's shortcomings in the variance column L and the last 4 lines is how I use the formula with manual overwriting to get the first and last month to be accurate for partial months.
All examples make it into the books on 09/30/12 so some line items have a "catchup" in cost recognition with coverage dates starting prior to 09/2012.
Let me know if you need any further info.
Thanks!!!
Bookmarks