Dates of Birth and ages

[Paully C]

Is there any way in Excel (or Access) to calculate an age from a date of birth, to include the number of months as well as years? It doesn't matter if the end result is two fields (i.e. years and left over months)

 

[beeawwb]

The Excel Function Dictionary (http://homepage.ntlworld.com/noneley/
contains this solution which I think is rather cool...

 

[Frank Kabel]

Hi Paully
have a look at
http://www.cpearson.com/excel/datedif.htm#Age

HTH
Frank

 

[Paully C]

Thanks that's great!