Sunday, August 11, 2013

yogi_Delineate Availability Of Age Per Specification If BirthDate is Available

                                          Google Spreadsheet   Post  #1325
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Aug, 11 2013

                                                                              UPDATED AUG-13-2013

user Bosler Morgan (!category-topic/docs/spreadsheets/scDD6lxBdnY)
Calculating Age; Returning Text String “Need Birthday” if birthday not entered
I'm trying to get my spreadsheet setup so that when I don't have a birthday entered in the "Birthday" cell, the "Age" cell will say, "Need Birthday".
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.

So, it's a little more complex than just the "age" calculation.  Any help is welcome!