Hi Jerry and everyone. What I love about maths is that there's always another way to calculate something!
On Wed, Apr 23, 2008 at 9:40 AM, NoOp <[EMAIL PROTECTED]> wrote: > I finally booted up Windows w/Excel 2002; there is no DateDif or > Yearfrac function listed - at all. > > Apparently the YEARFRAC function is only available in the Analysis > Toolpak add-in is installed. So apparently it's not a "standard" feature > of Excel and appears to be a VBA macro. It should always be possible to work out a formula without using complex functions. The fun is, working out how! Here is what I think you're after (working out the number of whole years between to dates - like someone's age) using simple functions. Assuming the two dates are in A1 and A2, the formula would be: =(YEAR(B1)-YEAR(A1))-IF(MONTH(B1)<MONTH(A1);0;DAY(B1)<DAY(A1)) I hope this helps! Reading over the thread was a bit complicated, and I found it hard to work out exactly what you're trying to do, so if I misunderstood, please let me know. Adrian
