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: 2885 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
12 October 2026
AUDIT , ACCOUNTS AND TAXATION

KDSS

New Delhi

B.Com

View Details
Company
ARTICLESHIP 07 October 2026
Article Trainee/ CMA Trainee

RMA And Associates LLP

New Delhi

CA Inter

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
05 October 2026
Senior Accountant

Vision IT Peripherals Pvt Ltd

Mumbai

B.Com

View Details
Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details