Copy the cell with the formula, and paste it down the column. The A1 will increment when you do
that.... Make sure that you don'e have $'s in your cell reference: A1 and not $A$1, for example.

HTH,
Bernie
MS Excel MVP


"jrchappell75" wrote in message
...
Wow That was fast. And it worked as well.

One other thing...
When I try to copy that the remaining column it copys the formula exactly.
How do I copy it to the remaining column so that the foruls compares the
birthdates for each player. There are close to 1000 players so doing it
manually wont work.

"Bernie Deitrick" wrote:

With the birthdate in cell A1:

For May 1, 2006

=DATEDIF(A1,DATE(YEAR(NOW()),5,1),"y")

or this, for May 1, 2005

=DATEDIF(A1,DATE(YEAR(NOW())-1,5,1),"y")