Subtract two dates and have result show up in years, months and days

[Marq]

Using Excel 2010

I want to take two dates and subtract them to give the difference

for example (cell A1) 8-1-2011 MINUS (cell B1) 4-1-11 = (cell C1)10 years 4 months

the formula being in cell C1

Can someple please show me how to do that?

 

[texasalynn]

oops - not what I wanted - try this

Excel Workbook
	A	B	C
1	8/1/2011	4/1/2001	10 years 4 months
Sheet1

Excel 2003

Cell Formulas
Range	Formula
C1	=DATEDIF(B1,A1,"y") & " years " & MONTH(A1)-MONTH(B1) & " months"

 

[Marq]

not working for me yet.....im getting the #NUM! error result....im copying and pasting the formaul you posted.

here are my actual cells and dates

cell B3 has 8-1-2000

cell O3 has 10-25-11

In cell L3 is where the formula goes. I guess breaking the difference into years, months , then days would actualy be more useful for what im doing.

so in L3 the formula would be O3-B3....result would read as 11 years 2 months 24 days

 

[T. Valko]

Using Excel 2010

I want to take two dates and subtract them to give the difference

for example (cell A1) 8-1-2011 MINUS (cell B1) 4-1-11 = (cell C1)10 years 4 months

the formula being in cell C1

Can someple please show me how to do that?

See this...

http://www.cpearson.com/Excel/datedif.aspx

 

[Marq]

got it working...THANKS!!!

 

[T. Valko]

got it working...THANKS!!!

Good deal. Thanks for the feedback!