>Actually, I should have been more specific. What I need is a function like:
>
>?GetTimeSpan({09/15/2000},{03/16/1999})
>
>Returns
>
>1.4673454
>
>Where I am getting caught up I guess is determining the number of days in a year.
>
>I know I am wrong so far from comparing my results with the textbook results for the same range. For example, my method (#days/365.25) gives
>
>9.5711 years
>
>and the book shows
>
>9.5816 years
>
>trouble is, I am fairly sure the 'book' uses a method called 30/360, I just don't know what that method is.
>
>Thanks for your input.
I think you should find the number of full years (9 in this case) and then work with the partial year separately. So use the year year(date())-1 and use the original month and day (and handle Feb.29 if you need to).
30/360 sounds like for partial years they use a 360 day year and for partial months they use a 30 day month. This would probably be used depending on whether a rate is compounded annually or monthly. I would look into the exact definition/methodology.
Joe
Joseph C. Kempel
Systems Analyst/Programmer
JNC