I would like to have the current age calculated in an excel spread sheet and
am having trouble with the formula. Any help appreciated. TIm
I would like to have the current age calculated in an excel spread sheet and
am having trouble with the formula. Any help appreciated. TIm
=YEAR(B1)-YEAR(A1)
will give you age in whole number.
Regards.
Bill Ridgeway
Computer Solutions
"Tim" <[email protected]> wrote in message
news:[email protected]...
>I would like to have the current age calculated in an excel spread sheet
>and
> am having trouble with the formula. Any help appreciated. TIm
"Bill Ridgeway" <[email protected]> wrote in message
news:[email protected]...
> =YEAR(B1)-YEAR(A1)
> will give you age in whole number.
Not quite. Suppose the DoB was 31st December? The *age* would be a year
out for all but one day of the year.
The DATEDIF function will calculate the age. DATEDIF is only in XL2000 Help
but Chip Pearson has a page on his website about it:
http://www.cpearson.com/excel/datedif.htm
=DATEDIF(A1,B1,"y")
Note that it takes the arguments: earliest date then later date
--
HTH
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks