Hi

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

Andy.

"kukarooza" wrote
in message ...

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.


--
kukarooza
------------------------------------------------------------------------
kukarooza's Profile:
http://www.excelforum.com/member.php...fo&userid=7797
View this thread: http://www.excelforum.com/showthread...hreadid=502903