How to hide 0 value

[shah_ir85]

Hello, i have one simple question

How to hide 0 value for Year or Month?

Start	Finish	Duration
1 Dec 19	20 Dec 20	1 Year 0 Month 19 Day
		=DATEDIF(RX232,RZ232,"Y")&" Year "&DATEDIF(RX232,RZ232,"YM")&" Month " &DATEDIF(RX232,RZ232,"MD")&" Day"

tQ in advanced

 

[Dossfm0q]

Book1
	RX		RZ	SA
231	Start		Finish	Duration
232	1-Dec-19		20-Dec-20	1 Year 0 Month 19 Day
233				1 Year Month 19 Day
Sheet2

Cell Formulas
Range	Formula
SA233	SA233	=SUBSTITUTE(DATEDIF(RX232,RZ232,"Y")&" Year "&DATEDIF(RX232,RZ232,"YM")&" Month "&DATEDIF(RX232,RZ232,"MD")&" Day","0 "," ")

 

[Dossfm0q]

Option

Book1
	RX	RY	RZ	SA
231	Start		Finish	Duration
232	1-Dec-19		20-Dec-20	1 Year 19 Day
Sheet2

Cell Formulas
Range	Formula
SA232	SA232	=TRIM(IF(DATEDIF(RX232,RZ232,"Y")<>0,DATEDIF(RX232,RZ232,"Y")&" Year "," ")&IF(DATEDIF(RX232,RZ232,"YM")<>0,DATEDIF(RX232,RZ232,"YM")&" Month "," ")&IF(DATEDIF(RX232,RZ232,"MD")<>0,DATEDIF(RX232,RZ232,"MD")&" Day"," "))

 

[shah_ir85]

tQ so much...done

 

[Dossfm0q]

Glad to help you