find (year,month, day)

[maarishiva]

I want find out exact "year_month_day" from two different dates

Pls let me know

Thanks
Mari

 

[Andrew Poulsom]

With the date in A1, do you mean?

=YEAR(A1)
=MONTH(A1)
=DAY(A1)

 

[maarishiva]

With the date in A1, do you mean?

=YEAR(A1)
=MONTH(A1)
=DAY(A1)

whatever date enter the cell in a1 and b2,
i want exact answer.. it possible?

Eg:

<TABLE style="WIDTH: 160pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=214><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=2 width=75><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20 width=75 align=right>Qus=11/11/1986_</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 width=75 align=right>10/21/2011</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=64>

</TD></TR></TBODY></TABLE> Ans=24yrs 11 months

 

[Matt Rogers]

Hello..
You mean this?

Excel Workbook
	A	B	C
1	11/11/1986	10/21/2011	24 Years - 11 Months - 10 Days
2	11/11/1986	10/21/2011	24 / 11 / 10
Sheet

 

[maarishiva]

thanks so much.. this is wat i expect

 

[Matt Rogers]

Thanks for your feedback and all the best!
Welcome here.