asset | date purchased | cost | prior | life | current depreciation | |
Ipad | 08/5/1996 | 2548 | 1687 | 5 | ||
<tbody>
</tbody>
I am using the folliowing formula:
=INT(ROUND(IF(C4<(EDATE($B$1,-12)+1),SLN(D4,0,F4),IF(AND(C4>=EDATE($B$1,-12)+1,C4<=$B$1),SLN(D4,0,F4)/12*(DATEDIF(C4,$B$1,"m")))),0))
The result is incorrect
cell b1 has value "07/31/18"
Help would be appreciated, specially in calculating depreciation when the final depreciation is in the last year