days between 2 dates

[hsandeep]

How to get no. of YEARS, MONTHS & DAYS between 2 dates (both days inclusive).
Thanks in adv

 

[VoG]

Try DATEDIF

Excel Workbook
	A	B	C
1	01/07/2003	15/06/2011	7 y 11 m 14 d
Sheet9

 

[hsandeep]

Try DATEDIF

Sheet9

	A	B	C
7 y 11 m 14 d

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:95px;"><col style="width:89px;"><col style="width:137px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: right"]01/07/2003[/TD]
[TD="align: right"]15/06/2011[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula C1 =DATEDIF(A1,B1,"y")&" y "&DATEDIF(A1,B1,"ym")&" m "&DATEDIF(A1,B1,"md")&" d" <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Excellent Sir! But I want 7 11 14 in 3 separate cells. How to accomplish this?

 

[VoG]

Try this

Excel Workbook
	A	B	C	D	E
1	01/07/2003	15/06/2011	7	11	14
Sheet9

 

[hsandeep]

Thanks Sir,

Please also help in the thread Match & Count posted by me today.