Depreciation Straight line Calculation based on start and end date

Hi Everyone, attached is my depreciation spreadsheet. I'm looking for help with calculating depreciation of an asset based on the asset cost and place in service and end date. The formulas in cell B15:K15 works if cell B9 (Useful Life) is a full year (i.e. 1, 2, 3 ,4 ,5). The formula does NOT work if the useful life is 1 year and 1 to 11 months. In the example in the attachment, B9 shows 1yr & 4mths. Notice how B15 & C15 totals $141,176 eventhough the total asset cost is only $100,000. Please help me......thanks!

Is this what you mean?

Thanks! This is PERFECT!