Excel formula for wdv calculations

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: 2873 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
14 July 2026
Senior Executive/ Manager

H S SHARMA AND CO

Pune

CA Final

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
ARTICLESHIP 10 July 2026
Article Assistant

N S Gokhale & Co

Thane

CA Inter

View Details
Company
23 July 2026
Semi qualified CA

Garg Bros & Associate CA

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 28 July 2026
Article/Intern/Semi-Qualified/Fresher B.Com

VNSS & Co

Mumbai

Others

View Details
Company
Featured 18 July 2026
Senior Manager- Finance & Accounts

apricus india

Ahmedabad

CA

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

G A R U D & Associates

New Delhi

CA Inter

View Details
Follow