Age Formula?? Wrote:
hi
I was wondering if anyone had a solution?
I have a formula cell with a date of birth and a cell with the date
now, and
i wanted to know whether i could work out a cell to work out a formula
for
excel to work out an age, and automatically change with the current
date.
Is this at all possable?
please email me with your responce to .
Thank you so much.
Hi Age Formula
In cell A1 put the Date of birth, in B1 put this formula =TODAY(), in
C1 put this formula =DATEDIF(A1,B1,"y")
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=476039