Thanks very much for all your replys.
I got it working as has saved me a lot of time
Thanks again
"Kevin B" wrote:
YOu can use this formula to calculate age:
=ROUND((TODAY()-A1)/365.254,2)
If you prefer not to round it to 2 decimal places use the following:
=(TODAY()-A1)/365.254
Formula assumes the date is in cell A1
--
Kevin Backmann
"David Biddulph" wrote:
Excel 2000 is the one version in which Excel help *does* include the DATEDIF
function. For other Excel versions, although the function is in Excel it is
the one function which Help omits (for an unknown reason), so the usual
source of information is http://www.cpearson.com/excel/datedif.htm
Note that it is not "DatedIF" (a derivative of IF), but DATEDIF, in other
words a DATE DIFference.
--
David Biddulph
" wrote in
message ...
Dear Claude,
From my posting, I had to do lots of stuff to get something close or just
barely near. I can't find DatedIF in my XLS 2000. Where did you get it
from?
<blur