Fixed Assets Remaining Life in Year and days.

(0) Share

Report

Posted on by sandipdjadhav

18,295

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)

Community Member on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Sandip,

No need to be sorry. I had just asked to know whether issue was resolved or not.

--

@dyngp_warren
sandipdjadhav 18,295 on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Hi Bob,

Sorry for delay in reply. Your updated excel code work like champ ! I was able to match depreciation amount.

Thanks much

Sandip Jadhav
Suggested answer

Community Member on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Sandip,

As requested I had sent the excel file, but did not hear back anything from you.

I hope that the excel file works out for you.

--

@dyngp_warren
Verified answer

Community Member on at

Like (0)

Report

RE: Fixed Assets Remaining Life in Year and days.

Done.

-Bob
sandipdjadhav 18,295 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.
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
Suggested answer

Victoria Yudin 22,768 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.
sandipdjadhav 18,295 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

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
Suggested answer

Victoria Yudin 22,768 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.