Forum Discussion
Suggestion and the recommendation of special functions depreciation
Excel includes 5 formulas to calculate depreciation (SLN,DB,DDB,VDB,SYD) and all of these formulas do not include cells for Starting Date and end date for the cycle to calculate depreciation using it...
=IF($A8=1,SLN($A$1,$A$2,$A$3)*((DATEDIF($A$4,$A$5,"ym")+1)/12), IF($A8=$A$3+1, ((12-((DATEDIF($A$4,$A$5,"ym")+1)))/12)*SLN($A$1,$A$2,$A$3),SLN($A$1,$A$2,$A$3)))
----------------- simple formula
