Conversion Days to Years / Months

[philb99]

Hi, is there any way to convert Total Days to show Years / Months / days please

 

[etaf]

assumes 31 days a month
=DATEDIF(0,A2,"y")&" Years "&DATEDIF(0,A2,"ym")&" Months "&DATEDIF(0,A2,"md")&" Days"

are you still using excel 2010 version - may be better ways

Better Excel formula converts days into Years, Months, Days

Here’s a better Excel formula for converting a number of days into text for year, months and days. This formula leaves out zero values and proper singular/p

office-watch.com

Book7
	A	B	C	D
1				removing zeros
2	32		0 Years 1 Months 1 Days	1 Months 1 Days
Sheet1

Cell Formulas
Range	Formula
C2	C2	=DATEDIF(0,A2,"y")&" Years "&DATEDIF(0,A2,"ym")&" Months "&DATEDIF(0,A2,"md")&" Days"
D2	D2	=IF(DATEDIF(0,A2,"y")<>0,DATEDIF(0,A2,"y")&" Years ","")& IF(DATEDIF(0,A2,"ym")<>0,DATEDIF(0,A2,"ym")&" Months ","")& IF(DATEDIF(0,A2,"md")<>0,DATEDIF(0,A2,"md")&" Days","")

 

[philb99]

Brilliant - works perfectly

 

[etaf]

you are welcome