+ Start a Discussion
Anirudh Sharma 5Anirudh Sharma 5 

formula field to calculate approximate Age?

I have a pick list called "Year" which referes to person Year of birth and I want to calculate the approximate age in years and display in a text field so how do write a formula field to get the Approx Age of the person. 

Thanks 
Best Answer chosen by Anirudh Sharma 5
JustAGirlyGeekJustAGirlyGeek
Sorry, try this instead:

TEXT(YEAR(TODAY() ) - VALUE(TEXT( Year__c )))

All Answers

JustAGirlyGeekJustAGirlyGeek
I haven't tested it but give this one a shot:

TEXT(YEAR(TODAY() ) - TEXT( Year__c ))
Anirudh Sharma 5Anirudh Sharma 5
Hey Thanks for the reply I tried but Its not working FYI the custom Year field that I created is a pick list
JustAGirlyGeekJustAGirlyGeek
Sorry, try this instead:

TEXT(YEAR(TODAY() ) - VALUE(TEXT( Year__c )))
This was selected as the best answer
Anirudh Sharma 5Anirudh Sharma 5
Thank you it worked