yogi_Compute Age In Years As Of A Specified Date From Date Born

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

brennan106 said:

i need a formula that will show age based on year born. I need it to automatically update when year changes
If I'd like to determine the age on a certain date every year such as August 1st, what would that formula be?
------------------------------------------------------------------