age cut off

[Sandyg]

How do I calculate the exact age, [b1] from date of birth [a1] and cut off
date that = 12-1-06? for basketball registration.

 

[JMB]

http://www.cpearson.com/excel/datedif.htm

There are examples to calculate a persons age. Instead of using Now() in
the formula, use Date(2006, 12, 1) or a reference to a cell containing
12/1/06.

 

[hot dogs]

example; insert =TODAY() into cell A1, this will put todays date into that
cell and will update to tomorrow's date when you open it tomorrow, and so on.
If your date of birth is in cell B1, then in cell C4 insert =(A1-B1)/365.25,
this will give an age (you have to format cell C4 to 'General') but the age
will have certain decimal places after it i.e. it will say the person is
17.5687 years old. So in cell C3 insert =LEFT(C4,2), this will give a 2 digit
age. Then hide cell C4 by setting the format to custom and inserting ;;; into
the 'Type:' box.