With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, March 14, 2018
yogi_Compute Years And Days For Given Numbers in Column A
question by: David Egan https://productforums.google.com/forum/#!topic/docs/Tk3fEOQeHg4;context-place=forum/docs Express a number in Years and Days
On a project I am working on I want to record how old a person was on a given date. Because I have their DOB and the given dates getting the number of days is easy, But I cannot figure out how to turn, for example I would like 11112 to output as "30 years 154 Days"