Hi subu, thanks, I did not know till now that Excel has a function called DateDif(), probably because it is not documented after Excel 2000. Anyways, thanks.
Ajit On Tue, Oct 7, 2008 at 7:23 AM, Subu <[EMAIL PROTECTED]> wrote: > It would be ideal to use datedif formula like this > C1 =DATEDIF(A1-1, B1, "Y") . For instance if your start date is 1-Jan-04 & > end date is 31-Dec04 then datedif (without -1) will give you 0 as years > where as you are expecting answer 1.. :) > > Regards > > Subu > > This will take care of the days issues > > On Mon, Oct 6, 2008 at 6:06 PM, Augustine <[EMAIL PROTECTED]> wrote: > >> Hi everybody, >> >> I tried using the DateDif function in Ms-Office 2007 but its not >> working. Is there any other way to activate the function since i heard that >> the function is hidden in Excel by Microsoft co. >> >> Thanks, >> Augustine >> >> On Sun, Sep 21, 2008 at 12:26 PM, Balachander S <[EMAIL PROTECTED]> wrote: >> >>> Try >>> a1 B1 c1 >>> 1-Jan-04 31-Mar-04 0 2-Jan-04 1-Apr-05 1 2 >>> >>> [c1] =DATEDIF(A1, B1, "Y") >>> >>> >>> On Sun, Sep 21, 2008 at 9:57 AM, vivek jain <[EMAIL PROTECTED]>wrote: >>> >>>> >>>> >>>> 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 >>>> >>>> >>>> >>>> >>> >> >> >> > > > -- > With warm regards, > Subu > > > > -- Thank You, Ajit Navre --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
