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     www.energyefficientbuild.com.

user WaumbaLady said: (http://productforums.google.com/forum/?zx=hin8ylq8ptdy#!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


No comments:

Post a Comment