Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug, 11 2013
user Bosler Morgan (http://productforums.google.com/forum/?zx=tswnkbvc9ab#!category-topic/docs/spreadsheets/scDD6lxBdnY)
Calculating Age; Returning Text String “Need Birthday” if birthday not entered
I should also reveal that I'm attempting a larger goal. To have a column that is the person's "Birthday Story". This could be a combination of many columns that are calculating the age in years, months and days. However, it would be nice to have one column with the entire birthday story that says: "Hi, my name is John Doe, I am 32 years, 5 months and 6 days old as of today, 08/11/2013. But, if the birthday column is not populated with a date, I want the text to read "Hi, my name is John Doe and I have not updated my contact information with my birthday as of today, 08/11/2013.