Dear All, I am preparing a fixed asset register for the last fifty years for an organization. I have to calculate the depreciation based on the no. of years an asset has been used. I have to calculate depreication upto 31/03/2004 and then for the f.y. 2004-05. Now I have to calculate the no. of years the asset has been used from the date of its acquisition to 31-03-2004. I have used the following formulae for this:- Say A1 is date of Acquisition (01/04/2000) In B1 I have applied the following formulae B1=2004-year(a1). But the problem in this formula is that if an asset has been acquired on 01/01/2004 it will show zero result whereas I want 1. Again if the asset has been acquired on 01/01/2005 it will show "-1" whereas I want it to be zero. Is there any other formula I can use.
Thanks & regards... CA Vivek Jain, FCA --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---