DateDif Question

[rcolving]

I have a spread sheet with two dates, I am using the following formula which works great if both cells are populated, but if one is not populated with a date I get #NUM!. If one of the cells is not populated I want the cell to be blank. =DATEDIF(D3,E3,"y") & " Years, " & DATEDIF(D3,E3,"ym") & " Months, " & DATEDIF(D3,E3,"md") & " Days"

 

[Rick Rothstein]

You could wrap your formula in an IFERROR function...

=IFERROR(DATEDIF(D3,E3,"y") & " Years, " & DATEDIF(D3,E3,"ym") & " Months, " & DATEDIF(D3,E3,"md") & " Days","")

 

[davesexcel]

If it comes up as an error,

=IFERROR(DATEDIF(E3,D3,"y") & " Years, " & DATEDIF(E3,D3,"ym") & " Months, " & DATEDIF(E3,D3,"md") & " Days","")

 

[Fluff]

Another option

=IF(OR(D3="",E3=""),"",DATEDIF(D3,E3,"y") & " Years, " & DATEDIF(D3,E3,"ym") & " Months, " & DATEDIF(D3,E3,"md") & " Days")

 

[rcolving]

That worked Thank you so much.

 

[Dave Patton]

Ensure the order of the dates is correct.

T202010a.xlsm
	D	E	F
3	1-Mar-20	1-Jan-20	0 Years, 2 Months, 0 Days
4
1c

Cell Formulas
Range	Formula
F3	F3	=IF(OR(D3="",E3=""),"",DATEDIF(E3,D3,"y") & " Years, " & DATEDIF(E3,D3,"ym") & " Months, " & DATEDIF(E3,D3,"md") & " Days")

 

[Fluff]

Glad we could help & thanks for the feedback.