Excel formula for wdv calculations

Others 10803 views 2 replies

Dear All,

Requested for urgent HELP ......

I required your help for calculating accumulated Depreciation one column for assets purchased for last 10 years on various dates.

For further classification excel working attached.....

(Calculative formula required to fill in yellow highlighted as per green calculation in one col as yellow).

If any further clarification required request to call me on 07760994856 (Bangalore) or email me on balagurrapu @ gmail.com.

Request treat this is some urgent requirement and thanks in advance for your help.....


Attached File : 261145 1176004 wdv depreciation calculation.xlsx downloaded: 2821 times
Replies (2)

The spreadsheet is attached. I don't remember seeing 1 day higer depreciation for leap year. If your calculation for leap year is right, my formula is off by that one day's working and I wouldnt be in a positon to bring it into one cell without significant efforts.

Will you please explain me why those numbers like 4 or 3  or 31 has been taken please. Any ways the formula worked for me thanks but i want to understand how it is working


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register