Calculating Age Based on Birthday

[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.

Hi

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

Andy.

"kukarooza" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>