The only way that would work is if you had your age in days

"Mark" wrote:

Hi,
A1 has todays date
A2 has your age
a3=a1-a2

-----Original Message-----
create a macro to calculate date of birth
.