Looking for a formula or VBA code that will return the age in the same cell where I had input the birthdate

[milt2010]

Hello to all,
as I wrote in the title, I would like to enter a birth date in a cell and get the corresponding age back in the same cell, after I press return or another key.

Thanks in advance for any help

 

[Michael M]

Ok.....have you tried the code with Sheets / cells unprotected ??

 

[milt2010]

Here the worksheet on Dropbox (no protection): http://bit.ly/2PBDxMB

 

[milt2010]

Ok.....have you tried the code with Sheets / cells unprotected ??

Yes, and the behavior is the same: working alone, not working together with other codes...

 

[milt2010]

I did another test, with the worksheet protected and I verified this: before protecting it all the codes work regularly; after activating the protection, the error message appears. And, even if I open the VBA and clear the bug and remove the protection, the code does not work (even if the error message no longer appears). So, I close and restart excel and then, the worksheet (unprotected) works fine again. Perhaps, besides the protection that maybe should be fixed with a code, there is some addin that creates problems to my excel (2016 - 365)...