excel formula (age)..

[spaced]

if in column A I have a person's date of birth, what formula will automatically insert their age into column B, without me having to manually work it out and type it in myself?

[Hammer]

=(today()-a1) / 365

[weegie-al]

or:
=year(today())-year(a1)

[PatTheRat]

I had a look at the formula you used weegie-al.....i think its wrong somewhere as it only gives what age the person will be turning this year. Tried it out, and used the two dates of 01/01/1980 and 31/12/1980. Both brought up the same age of 26, when the second one should still be 25.

This is a formula I have seen used before: =INT((TODAY()-A2)/365.25) , as a note to spaced, you might need to change the A2 part to whatever your first cell with a date in it is.

[PatTheRat]

Sorry, forgot to mention about the formula I used. If its your birthday today, it wont register you as a year older until the next day, so it has a flaw there too.

[PatTheRat]

=IF(MONTH(TODAY())>MONTH(A1),YEAR(TODAY())-YEAR(A1),IF(AND(MONTH(TODAY())=MONTH(A1),DAY(TODAY())>=DAY(A1)),YEAR(TODAY())-YEAR(A1),(YEAR(TODAY())-YEAR(A1))-1))

Got this off some website, so its not my own work, but apparently this should work 100%. Apologies for posting so many times.