Formula for finding Age

[Apple1]

Dear All

Using Excel 2007.

I have the date of birth in column A in the format dd/mm/yyyy.

I want to find the age in another column. And the age has to auto-update with each passing year.

How do I achieve this in Excel or Access?


Thank you.

[daddylonglegs]

In Excel use DATEDIF, e.g in B2

=DATEDIF(A2,TODAY(),"y")