How to average two dates and return diffrence in months and years from today

[Parkerpen13]

I have two dates of coats and pants. I would like to average the dates from today and return how old the two dates together are from today.

Coat Manufacture Date	Pants Manufacture Date
2/04	4/99
1/09	1/09
4/99	1/09
5/15	6/16
4/99	4/99
12/01	5/15
2/05	5/15
6/16	5/15
5/98	6/16
5/14	5/14
5/15	5/14
2/14	6/16
5/14	5/14

<tbody>
</tbody><colgroup><col span="2"></colgroup>

 

[sheetspread]

Excel 2010
	A	B	C	D	E
1	Coat Manufacture Date	Pants Manufacture Date	Average	Years	Months
2	2/1/2004	4/1/1999	8/31/2001	16	6.47
3	1/1/2009	1/1/2009	1/1/2009	9	2.43
4	4/1/1999	1/1/2009	2/15/2004	14	0.97
5	5/1/2015	6/1/2016	11/15/2015	2	3.97
6	4/1/1999	4/1/1999	4/1/1999	18	11.43
7	12/1/2001	5/1/2015	8/15/2008	9	6.97
8	2/1/2005	5/1/2015	3/17/2010	7	11.9
9	6/1/2016	5/1/2015	11/15/2015	2	3.97
10	5/1/1998	6/1/2016	5/17/2007	10	9.9
11	5/1/2014	5/1/2014	5/1/2014	3	10.43
12	5/1/2015	5/1/2014	10/30/2014	3	4.47
13	2/1/2014	6/1/2016	4/2/2015	2	11.4
14	5/1/2014	5/1/2014	5/1/2014	3	10.43
Sheet9

Cell Formulas
Range	Formula
C2	=AVERAGE(A2,B2)
D2	=INT(YEARFRAC(C2,TODAY()))
E2	=ROUND(12*MOD(YEARFRAC(C2,TODAY()),1),2)

 

[Parkerpen13]

This works great however is there a way to combine this into one function and display it as 1 year 1 month?

 

[sheetspread]

This?

Excel 2010
	A	B	C	D
1	Coat Manufacture Date	Pants Manufacture Date	Average
2	2/1/2004	4/1/1999	8/31/2001	16 year 6.47 month
3	1/1/2009	1/1/2009	1/1/2009	9 year 2.43 month
4	4/1/1999	1/1/2009	2/15/2004	14 year 0.97 month
5	5/1/2015	6/1/2016	11/15/2015	2 year 3.97 month
6	4/1/1999	4/1/1999	4/1/1999	18 year 11.43 month
7	12/1/2001	5/1/2015	8/15/2008	9 year 6.97 month
8	2/1/2005	5/1/2015	3/17/2010	7 year 11.9 month
9	6/1/2016	5/1/2015	11/15/2015	2 year 3.97 month
10	5/1/1998	6/1/2016	5/17/2007	10 year 9.9 month
11	5/1/2014	5/1/2014	5/1/2014	3 year 10.43 month
12	5/1/2015	5/1/2014	10/30/2014	3 year 4.47 month
13	2/1/2014	6/1/2016	4/2/2015	2 year 11.4 month
14	5/1/2014	5/1/2014	5/1/2014	3 year 10.43 month
Sheet9

Cell Formulas
Range	Formula
C2	=AVERAGE(A2,B2)
D2	=INT(YEARFRAC(C2,TODAY()))&" year "&ROUND(12*MOD(YEARFRAC(C2,TODAY()),1),2)&" month"

(the rounding can be adjusted to preference)

 

[Parkerpen13]

Works perfect but is there a way to include the average function in the longer function so I don’t have to add th average column? I appreciate your help.

 

[sheetspread]

Sure:

Excel 2010
	A	B	C
1	Coat Manufacture Date	Pants Manufacture Date
2	2/1/2004	4/1/1999	16 year 6.47 month
3	1/1/2009	1/1/2009	9 year 2.43 month
4	4/1/1999	1/1/2009	14 year 0.97 month
5	5/1/2015	6/1/2016	2 year 3.97 month
6	4/1/1999	4/1/1999	18 year 11.43 month
7	12/1/2001	5/1/2015	9 year 6.97 month
8	2/1/2005	5/1/2015	7 year 11.9 month
9	6/1/2016	5/1/2015	2 year 3.97 month
10	5/1/1998	6/1/2016	10 year 9.9 month
11	5/1/2014	5/1/2014	3 year 10.43 month
12	5/1/2015	5/1/2014	3 year 4.47 month
13	2/1/2014	6/1/2016	2 year 11.4 month
14	5/1/2014	5/1/2014	3 year 10.43 month
Sheet9

Cell Formulas
Range	Formula
C2	=INT(YEARFRAC(AVERAGE(A2,B2),TODAY()))&" year "&ROUND(12*MOD(YEARFRAC(AVERAGE(A2,B2),TODAY()),1),2)&" month"