Not exactly tested, ubt a start:
******** ******************** ************************************************************************><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" bgColor=#0c266b colSpan=5><TABLE border=0 width="100%" align=center><TBODY><TR><TD align=left>
Microsoft Excel - Book1</TD><TD style="FONT-FAMILY: caption; COLOR: #ffffff; FONT-SIZE: 9pt" align=right>___Running: xl2000 : OS = Windows Windows 2000 </TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px; BORDER-RIGHT: #000000 0.5pt solid" bgColor=#d4d0c8 colSpan=5><TABLE border=0 width="100%" align=center VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-FAMILY: caption; COLOR: #000000; FONT-SIZE: 10pt">
File
Edit
View
Insert
Options
Tools
Data
Window
Help
About</TD><TD vAlign=center align=right><FORM name=formCb330421><INPUT value="Copy Formula" type=button name=btCb269281 *******='window.clipboardData.setData("Text",document.formFb352207.sltNb994220.value);'></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" bgColor=white colSpan=5><TABLE border=0><TBODY><TR><FORM name=formFb352207><TD style="WIDTH: 60px" bgColor=white align=middle><SELECT onchange="document.formFb352207.txbFb438278.value = document.formFb352207.sltNb994220.value" name=sltNb994220><OPTION selected value==TODAY()-A2>B2<OPTION value==TODAY()-A3>B3<OPTION value==TODAY()-A4>B4<OPTION value==TODAY()-A5>B5<OPTION value==TODAY()-A6>B6<OPTION value==SUM(B2:B6)/COUNT(A2:A6)>B8<OPTION value='=INT(B8/365)&" Years, "&INT(MOD(B8,365)/30)&" Months, "&ROUND(MOD((MOD(B8,365)),30),0)&" Days"'>B9</OPTION></SELECT></TD><TD bgColor=#d4d0c8 width="3%" align=right>
=</TD><TD bgColor=white align=left><INPUT value==TODAY()-A2 size=80 name=txbFb438278></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" width="2%" align=middle>
</TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>A</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>B</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>C</CENTER></TD><TD style="BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: black; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=middle><CENTER>D</CENTER></TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>1</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid">Date</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid">Days*Old</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>2</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">1/01/2001</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">
1037</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>3</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">1/01/2001</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">
1037</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>4</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">1/02/2001</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">
1006</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>5</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">1/03/2001</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">
978</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>6</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">1/12/1950</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">
19331</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>7</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>8</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">Average:</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">
4678</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; FONT-FAMILY: menu; COLOR: #000000; FONT-SIZE: 10pt; BORDER-TOP: #000000 0.5pt solid" width="2%" align=middle><CENTER>9</CENTER></TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">Age</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">
12*Years,*9*Months,*28*Days</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #d4d0c8 0.5pt solid">*</TD><TD style="BORDER-BOTTOM: #d4d0c8 0.5pt solid; BACKGROUND-COLOR: #ffffff; FONT-FAMILY: Arial; COLOR: #000000; FONT-SIZE: 10pt; BORDER-RIGHT: #000000 0.5pt solid">*</TD></TR><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" colSpan=5><TABLE width="100%" align=left VALIGN="TOP"><TBODY><TR><TD style="BORDER-BOTTOM: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #ffffff; WIDTH: 120pt; BORDER-TOP: #808080 0.5pt solid; BORDER-RIGHT: #000000 0.5pt solid" align=left>
Sheet1</TD><TD>*</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
[HtmlMaker light Ver1.10] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.</CENTER>
the formula is:
=INT(B8/365)&" Years, "&INT(MOD(B8,365)/30)&" Months, "&ROUND(MOD((MOD(B8,365)),30),0)&" Days"
..which, even if along the right lines, is clearly an approximation given the assumptions about how long months & years are.