I have been searching for formulas to write the age today of my list of people. The problem that I had is regarding the value that pops out... It is always #VALUE . As far as I can remember, I followed the formula and the formatting of the cell. Help please? Thank you so much! 
Age Today formula
-
-
What formula have you used?
-
Carim
Changed the title of the thread from “#VALUE result whenever I use the Age Today formula” to “Age Today formula”. -
Hi,
For Future Readers ... the Age Formula expressed in Years, Months and Days :
Code=DATEDIF(A1,TODAY(),"y")&" y "&DATEDIF(A1,TODAY(),"ym")&" m "&DATEDIF(A1,TODAY(),"md")&" d "Hope this will help
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!