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