I’ve read the previous thread, plus John Walkenbach’s excellent ‘XL2003 Bible’, but am still getting wrong answers!
In column A I have birthdates, formatted dd/mm/yyyy and named range ‘birthdate’
In column B I have the formula
=(today()-birthdate)/365.25 etc, copied down. This is formatted as a number, 3 decimal places.
Today’s date as at writing is 18 Feb 2010 and the computer clock shows that date.
With a selection of birthdates like 18/02/yyyy I’d expect to find reported values of exactly an integral number of years.
From a choice of ‘birthyears’, I only get that for birthdate = 18/02/1910, which returns 100.000 (and good for 6 decimal places, in fact) and 18/02/2000, returning 20.000
All others show small supplements to a whole number of years.
The same situation occurs using the DATEDIF function (which I want to avoid anyway as it can’t handle future birthdates, ie negative ages)
I really would like someone born 10 years ago today to show as precisely 10 years old, not 10.001(369…)
What’s the trick, please?
I suspect that it might be a question of how many 29 Februaries intervene? If so, what’s the fix?
And why won’t it handle birthdates before the year 1900? (but that’s less important.)
Thanks!
John