Excel formula for wdv calculations

Others 11077 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: 2855 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  

Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details