vlookup to capture asset purchase totals and depreciation

Trying to come up with a few formulas that will calculate depreciation based on a purchase date so it'll populate in the appropriate columns (I have the first year by quarter and the subsequent years annually). And then also to pull the asset category from the first schedule onto another page, to total the asset purchases and the depreciation, again by period. Hope this makes sense, and that my attached spreadsheet is clear! Having trouble explaining what I'm trying to do so I apologize in advance for any discrepancy!!

Thanks for your help Excel Gurus!!

Sorry about that, please see revised spreadsheet attached.

Hi Flame,
I'm a bit confused on the 30.4375 portion of this formula ..... =IF(H$3>$D4,ROUND((H$3-$D4)/30.4375,0)*$G4,"")

Can you explain that to me? In your spreadsheet the numbers come out correctly, but when I copy the formula over into my working spreadsheet, it ends up calculating cumulatively - so that each quarter adds to the subsequent one. For example, I'm trying to get the formula to calculate just the depreciation relevant to the time period in the header. So if the header if 3/31/16, that would be a quarter end and so would only capture depreciation for Jan, Feb, and March of 2016. And then the next period would be Apr, May, June (ending 6/30/16) and would only capture depreciation for those three months. Does that make sense? The spreadsheet you attached has all the right headers and examples, but I'm not sure how to adjust the formula so it will capture just those periods in and of themselves. I think the other formulas worked out correctly because they were cumulative. Thank you again so much for your expert help!!!

Sorry, Actually I misspoke. In what I just posted a few minutes a go, I said the numbers come out correctly in your spreadsheet and when I copy them over they end up cumulative for depreciation. Your spreadsheet is cumulative as well, so at least I'm not messing up the formula. But I'm trying to get the depreciation piece to just be per period, not cumulative. Sorry for mis-typing on that one!!

Here's my attempt.
Add a column in between G and H (so new H)

I5:

Formula:

Please Login or Register  to view this content.

*DATEDIF does not like 31-May 30-Jun as 1 month... annoyingly.

B20:

Formula:

Please Login or Register  to view this content.

and, B26

Formula:

Please Login or Register  to view this content.

=(IF(H$3>$D4,DATEDIF($D4,H$3,"m"),"0"))*$G4

put this simple code and in H4 and see the result. {never forget to drug in other cells where u want your depriciation.}

Get your complete solution with all formula and calculations.