Difficulty with an Age macro

[Mister P]

I'm working on project where I need a person's age on a specified date displayed as a decimal value. The code I have so far displays the age as a whole number.

Please Login or Register  to view this content.

I've attached a sample workbook.

Mister P

[Leith Ross]

Hello Mister P,

The problem is you are returning the difference in whole years. There are many decimal fractions that could be used like days or months. I decided on months. Here is the loop with the change to reflect the age in years with the decimal based on months.

Please Login or Register  to view this content.

[Mister P]

Leith,
This is exactly what I was trying to accomplish. Perfect for my application. Thank you so much.

Mister P