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
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