RE: Calculating Age in Years and Months
Sue Sloan 17.Jul.08 12:00 PM a Web browser
Approach 9.7 Windows XP
A quick search on XpertSS.com finds this formula posted back in 2001:
The following formula produces a line of text e.g. "Age: 32 yrs 6 mths". If the BirthDate is empty them it produces an empty text string.
Age = If(Isblank(BirthDate),'',If((Month(Today()) - Month(BirthDate)) < 0, Combine('Age: ', (Year(Today()) - Year(BirthDate) - 1),' yrs ',(12 + Month(Today()) - Month(BirthDate)),' mths'),Combine('Age: ', (Year(Today()) - Year(BirthDate)),' yrs ',(Month(Today()) - Month(BirthDate)),' mths')))
Sue Sloan
XpertSS.com
 Calculating Age in Years and Months... (S. Moore 17.Jul.08)
 . . RE: Calculating Age in Years and Mo... (Sue Sloan 17.Jul.08)
. . . . RE: Calculating Age in Years and Mo... (S. Moore 17.Jul.08)
| 
Return to top
Print this page
