calculate age using BD and (TODAY)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Bill Ridgeway said:
=YEAR(B1)-YEAR(A1)
will give you age in whole number.
Click to expand...

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 
Back
Top