Incremental Division [Almost there]

I have hours in columns extended out several years by month. For this example it starts at A1. In another spreadsheet I have those months split with 2 dates for every month. What I need to do is to come up with a formula that will allow me to divide each month evenly to spread across the 2 dates for the correlating month on the spreadsheet with two dates for each month. I have hundrunds of line items that span over 10 years so a formula will help tremendously. Also, if someone has a better recommendation for a title of this thread please let me know.


January-12 February-12 March-12 April-12
100 100 100 100
1/8/2012 1/26/2012 2/10/2012 2/23/2012 3/6/2012 3/20/2012 4/10/2012 4/28/2012
50 50 50 50 50 50 50 50

Can you upload an example spreadsheet (Go Advanced > Manage Attachments)? That would help.

Try this in A4 dragged to the right. If the monthly number is odd, it adds 1 to the first monthly value (i.e. if the total is 81, you'll get 41 and 40)

Please Login or Register  to view this content.

Does this work for you?

Never mind, it was the $ sign on the first portion of the range of the Hlookup.