Monday, August 27, 2012

yogi_Compute Age In Years If Over 2 Years Otherwise In Months

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #715   Aug 27, 2012

user WaumbaLady said: (!category-topic/docs/spreadsheets/NLWQI5WerE0)
age (year) calculation

I have a need that is a little special.  Would it be possible to tweak the above formula such that it would give the persons age in months IF the person was less than 2 years old?  I am director of a children's ministry at our church and this would be awesome.  I would like it to display with an "m" or "mos" after the value if possible, e.g. 18m or 
18 mos. 
Thank you for your time!!
in some other posts
I have provided a generalized solution providing the difference in from to dates in Years only
and also in Years, Months, and Days
In this post I provide a solution for problem posed by WaumbaLady