Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Fixed Assets Remaining...
Microsoft Dynamics GP (Archived)

Fixed Assets Remaining Life in Year and days.

(0) ShareShare
ReportReport
Posted on by sandipdjadhav 18,269

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

  • Community Member Profile Picture
    Community Member on at
    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 Profile Picture
    sandipdjadhav 18,269 on at
    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 Profile Picture
    Community Member on at
    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 Profile Picture
    Community Member on at
    RE: Fixed Assets Remaining Life in Year and days.

    Done.

    -Bob

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,269 on at
    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 Profile Picture
    Community Member on at
    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.

    1376.Untitled1.png

    -Bob

  • Suggested answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    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 Profile Picture
    sandipdjadhav 18,269 on at
    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 Profile Picture
    Community Member on at
    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 Profile Picture
    Victoria Yudin 22,766 on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans