Depreciation Schedule in excel

[almst791]

Hi all.

I need a solution, I have a large data set with the start date and end date for a bunch of assets along with the monthly depreciation

I need a running pivot table with my total depreciation amount every month (It should drop off over time).

Is it possible to do this?