Dates difference

[mrod]

How do I show difference between two dates <TABLE style="WIDTH: 140pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=187><COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6838" width=187><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 140pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=19 width=187>1/1-2011 - 7/28/1997</TD></TR></TBODY></TABLE> show as <TABLE style="WIDTH: 140pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=187><COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6838" width=187><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 140pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66 height=19 width=187>13 yrs., 5 mos., 4 days</TD></TR></TBODY></TABLE>

thx u!

 

[schielrn]

Welcome to the Board!

Maybe try:

Excel Workbook
	A	B	C
32	1/1/2011	7/28/1997	13 Year(s) 5 Month(s) 4 Day(s)
Employees

Cell Formulas
Range	Formula
C32	=DATEDIF(B32,A32,"y")&" Year(s) "&DATEDIF(B32,A32,"ym")&" Month(s) "&DATEDIF(B32,A32,"md")&" Day(s)"

Hope that helps.