Answered

Fixed Assets Remaining Life in Year and days.

(0) Share

Report

Posted on by sandipdjadhav

Remaining Life in Year and days.

I have assets which Total Years in Life is 35 Months i.e. 2 Years on 11 Months. Place in Service is 12/01/2014

But in fixed assets option to enter Remaining Life in Year and Days. To calculate days I have to 11*30 =330 or I have to calculate exact Years & Days in between Place in Service and last date of depreciation. If yes then is there any formula in excel to get Years and Remaining Days?

My Depreciation method is Straight Line Original Life.

Your earliest reply is highly appreciable.

Thanks Much

Sandip Jadhav

*This post is locked for comments

All responses (13)

Answers (1)

Almas Mahfooz on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

>>>> My Depreciation method is Straight Line Original Life.

I didn't know you are depreciating. lol. :P~~~
sandipdjadhav on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

@Almas, That is also Original Life !

Anyhow, do you have any answer to my question?

Thanks Much
Almas Mahfooz on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

In original life there is only death no Depreciation :P~

If I had, I would already replied, but these kinds of questions could only be replied by someone like

Leslie or Al-Saadi or others like them. : )
Suggested answer

Victoria Yudin on at

Like (1)

Report

RE: Fixed Assets Remaining Life in Year and days.

Sandip,

Might be easiest to do this in Excel - enter the start date and end date into 2 different cells, in a 3rd cell, subtract one from another. Excel will calculate the exact number of days for you.
Suggested answer

Community Member on at

Like (1)

Report

RE: Fixed Assets Remaining Life in Year and days.

Hi Sandip,

It's very simple in excel to find date difference in Days,weeks,months and years by using Datediff VBA excel function.

www.techonthenet.com/.../datediff.php

-Bob
sandipdjadhav on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Hi Vicotria, Much appreciate for your reply.

That will give me result in Days only. E.g for 33 months it should give me 2 yrs and (9*30) Or How I will get exact remaining days?

Tks

Sandip
Suggested answer

Victoria Yudin on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

You know there are 2 years and 11 months, right? Let's say you place the asset in service on 4/15/2016. The 2 years will be over on 4/14/2018, then you need 11 months from there. That would be 3/14/2019. So in Excel you need to calculate the difference between 4/15/2018 and 3/14/2019 - I get 333 days. In Fixed Assets you would enter 2 years and 333 days. Let me know if I missed something in my logic.
Community Member on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Sandip,

Excel file ready with me. But don't know how to attached in this.

Let me know how I can send it to you.

-Bob
sandipdjadhav on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Hi Bob, Can you send it to my personal email ID: sandipdjadhav@hotmail.com. Much Appreciate for your help.
Verified answer

Community Member on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Done.

-Bob