Ages help please!

[Blade2304]

I am trying to put formulas into a worksheet to calculate current ages in years. For example, column A= date of birth and B calculates the persons age based on the current date, in years, thus updating automatically each year. I guess i need to use a column for the 'now' formula to check at the current date but i dont know how to use it to compare with the date of birth column and return an age. Any help much appreciated!!

[jtp]

Try this:

=DATEDIF(F1,TODAY(),"Y")

[jtp]

Replace F1 with A1...Sorry

[Blade2304]

Thankyou it does what i want, didnt know that formula existed, infact i cant find it in my functions list

[Bryan Hessey]

The function that jtp gave you, together with other date items, can be seen at
http://www.cpearson.com/excel/datedif.htm

--

Thankyou it does what i want, didnt know that formula existed, infact i cant find it in my functions list