Calculating Age Based on Birthday

K

kukarooza

I use the formula =datedif(A1,B1,"y") assuming that column A has the
person's birthday and column B has today's date. When I copy this
formula to other rows, the B1 automatically increments by 1 each time.
I want the formula to stay B1 all the way down. Ideas?
Thanks.:confused:
 
G

Guest

Hi

You need to make the reference absolute (not relative). Try:
=datedif(A1,$B$1,"y")

Andy.
 
Top