On Tue, 22 Apr 2008 15:39:06 +0100 Brian Barker <[EMAIL PROTECTED]> wrote:
> If I understand your needs correctly, try (in Calc): > =INT(YEARFRAC($A$1;$B1;1)) > The YEARFRAC function determines the actual difference - and > therefore age - in years and fractions of a year. The INT function > discards the fraction to leave the whole years that you evidently > need. Excel has a YEARFRAC function, which I assume is similar. As > I said before, I do not have Excel available with which to check this. Many thanks Brian, I have tested YEARFRAC() in my test case and it works very well in both Excel and Calc. I had asked this question in a few different listservs, possibly even this one. And, 2 of my coworkers are PHD/Actuaries. Not one other person mentioned yearfrac(). Now comes the hard part, getting my coworker to replace the datedif formulae with yearfrac. -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
