Google Spreadsheet Post #1325
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug, 11 2013
UPDATED AUG-13-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.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug, 11 2013
UPDATED AUG-13-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'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".
Help?
https://docs.google.com/
---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!
Bosler
--------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment